Data replication is favored where most process requests are read-only and where the data are relatively static. False True TRUE ANSWER : ? YOUR ANSWER : ?
In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned. True False TRUE ANSWER : ? YOUR ANSWER : ?
A distributed database has which of the following advantages over a centralized database? Software complexity Slow Response Modular growth Software cost TRUE ANSWER : ? YOUR ANSWER : ?
Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment. False True 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 not distributed across all nodes. A different DBMS is used at each location and data are distributed across all nodes. The same DBMS is used at each location and data are not distributed across all nodes. TRUE ANSWER : ? YOUR ANSWER : ?
The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex. True False 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 : ?
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 : ?
A distributed database can use which of the following strategies? Totally centralized at one location and accessed by many sites Partitioned into segments at different sites Partially or totally replicated across sites All of these TRUE ANSWER : ? YOUR ANSWER : ?