Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment. True False 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 distributed database has which of the following advantages over a centralized database? Slow Response Software cost Software complexity Modular growth TRUE ANSWER : ? YOUR ANSWER : ?
Data replication is favored where most process requests are read-only and where the data are relatively static. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is a disadvantage of replication? If the database fails at one site, a copy can be located at another site. Each transaction may proceed without coordination across the network. Reduced network traffic Each site must have the same storage capacity. TRUE ANSWER : ? YOUR ANSWER : ?
A homogenous distributed database is which of the following? The same DBMS is used at each location and data are distributed across all nodes. A different DBMS is used at each location and data are distributed across all nodes. A different DBMS is used at each location and data are not distributed across all nodes. The same DBMS is used at each location and data are not distributed across all nodes. 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. True False TRUE ANSWER : ? YOUR ANSWER : ?
Each site (or node) in a distributed system is subject to the same types of failure as in a centralized system. True False 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. True False TRUE ANSWER : ? YOUR ANSWER : ?