1. | A distributed database has which of the following advantages over a centralized database? |
Discuss |
Answer: (d).Modular growth
|
2. | An autonomous homogenous environment is which of the following? |
Discuss |
Answer: (a).The same DBMS is at each node and each DBMS works independently.
|
3. | A transaction manager is which of the following? |
Discuss |
Answer: (d).All of the above
|
5. | A heterogeneous distributed database is which of the following? |
Discuss |
Answer: (d).A different DBMS is used at each location and data are distributed across all nodes.
|
6. | Some of the columns of a relation are at different sites is which of the following? |
Discuss |
Answer: (c).Vertical Partitioning
|
7. | Which of the following is true concerning a global transaction? |
Discuss |
Answer: (b).The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
|
8. | A homogeneous distributed database is which of the following? |
Discuss |
Answer: (b).The same DBMS is used at each location and data are distributed across all nodes.
|
9. | Replication should be used when which of the following exist? |
Discuss |
Answer: (c).The application's data can be somewhat out-of-date.
|
10. | Storing a separate copy of the database at multiple locations is which of the following? |
Discuss |
Answer: (a).Data Replication
|