Location transparency allows for which of the following? Managers to treat the data as if it is at one location All of these Programmers to treat the data as if it is at one location Users to treat the data as if it is at one location 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 : ?
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 : ?
The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is true concerning a global transaction? The required data are at one local site and the distributed DBMS routes requests as necessary. The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS. TRUE ANSWER : ? YOUR ANSWER : ?
With failure transparency, all of the actions of a transaction are committed or none of them are committed. False True TRUE ANSWER : ? YOUR ANSWER : ?
Replication should be used when which of the following exist? All of these The application's data can be somewhat out-of-date. When transmission speeds and capacity in a network prohibit frequent refreshing of large tables. When using many nodes with different operating systems and DBMSs and database designs. TRUE ANSWER : ? YOUR ANSWER : ?
A transaction manager is which of the following? Maintains a log of transactions Maintains appropriate concurrency control Maintains before and after database images All of these TRUE ANSWER : ? YOUR ANSWER : ?
A distributed database has which of the following advantages over a centralized database? Software cost Modular growth Software complexity Slow Response TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not one of the stages in the evolution of distributed DBMS? Remote unit of work Unit of work Distributed request Distributed unit of Work TRUE ANSWER : ? YOUR ANSWER : ?