Replication should be used when which of the following exist? When using many nodes with different operating systems and DBMSs and database designs. All of these When transmission speeds and capacity in a network prohibit frequent refreshing of large tables. The application's data can be somewhat out-of-date. 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 : ?
Data replication is favored where most process requests are read-only and where the data are relatively static. 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. False True TRUE ANSWER : ? YOUR ANSWER : ?
Some of the columns of a relation are at different sites is which of the following? Horizontal and Vertical Partitioning Data Replication Horizontal Partitioning Vertical Partitioning TRUE ANSWER : ? YOUR ANSWER : ?
A heterogeneous distributed database is which of the following? The same 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 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 distributed across all nodes. 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. False True TRUE ANSWER : ? YOUR ANSWER : ?
A distributed database has which of the following advantages over a centralized database? Software complexity Modular growth Software cost Slow Response TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not one of the stages in the evolution of distributed DBMS? Distributed request Remote unit of work Distributed unit of Work Unit of work TRUE ANSWER : ? YOUR ANSWER : ?