Data replication is favored where most process requests are read-only and where the data are relatively static. True False TRUE ANSWER : ? YOUR ANSWER : ?
Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update. False True TRUE ANSWER : ? YOUR ANSWER : ?
A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations. False True TRUE ANSWER : ? YOUR ANSWER : ?
A transaction manager is which of the following? Maintains before and after database images All of these Maintains appropriate concurrency control Maintains a log of transactions TRUE ANSWER : ? YOUR ANSWER : ?
Storing a separate copy of the database at multiple locations is which of the following? Horizontal and Vertical Partitioning Horizontal Partitioning Vertical Partitioning Data Replication TRUE ANSWER : ? YOUR ANSWER : ?
Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not one of the stages in the evolution of distributed DBMS? Remote unit of work Distributed request Distributed unit of Work Unit of work TRUE ANSWER : ? YOUR ANSWER : ?
Some of the columns of a relation are at different sites is which of the following? Horizontal and Vertical Partitioning Horizontal Partitioning Data Replication Vertical Partitioning TRUE ANSWER : ? YOUR ANSWER : ?
With asynchronous technology, if any copy of a data item is updated anywhere on the network, the same update is immediately applied to all other copies or it is aborted. False True TRUE ANSWER : ? YOUR ANSWER : ?
Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases. True False TRUE ANSWER : ? YOUR ANSWER : ?