| 1. | A distributed database has which of the following advantages over a centralized database? |
| a. | Software cost |
| b. | Software complexity |
| c. | Slow Response |
| d. | Modular growth |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (d).Modular growth
|
| 2. | An autonomous homogenous environment is which of the following? |
| a. | The same DBMS is at each node and each DBMS works independently. |
| b. | The same DBMS is at each node and a central DBMS coordinates database access. |
| c. | A different DBMS is at each node and each DBMS works independently. |
| d. | A different DBMS is at each node and a central DBMS coordinates database access. |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (a).The same DBMS is at each node and each DBMS works independently.
|
| 3. | A transaction manager is which of the following? |
| a. | Maintains a log of transactions |
| b. | Maintains before and after database images |
| c. | Maintains appropriate concurrency control |
| d. | All of the above |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (d).All of the above
|
| 4. | Location transparency allows for which of the following? |
| a. | Users to treat the data as if it is at one location |
| b. | Programmers to treat the data as if it is at one location |
| c. | Managers to treat the data as if it is at one location |
| d. | All of the above |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (d).All of the above
|
| 5. | A heterogeneous distributed database is which of the following? |
| a. | The same DBMS is used at each location and data are not distributed across all nodes. |
| b. | The same DBMS is used at each location and data are distributed across all nodes. |
| c. | A different DBMS is used at each location and data are not distributed across all nodes. |
| d. | A different DBMS is used at each location and data are distributed across all nodes. |
| View Answer Report Discuss Too Difficult! Search Google |
|
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? |
| a. | Data Replication |
| b. | Horizontal Partitioning |
| c. | Vertical Partitioning |
| d. | Horizontal and Vertical Partitioning |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (c).Vertical Partitioning
|
| 7. | Which of the following is true concerning a global transaction? |
| a. | The required data are at one local site and the distributed DBMS routes requests as necessary. |
| b. | The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary. |
| c. | The required data are at one local site and the distributed DBMS passes the request to only the local DBMS. |
| d. | The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS. |
| View Answer Report Discuss Too Difficult! Search Google |
|
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? |
| a. | The same DBMS is used at each location and data are not distributed across all nodes. |
| b. | The same DBMS is used at each location and data are distributed across all nodes. |
| c. | A different DBMS is used at each location and data are not distributed across all nodes. |
| d. | A different DBMS is used at each location and data are distributed across all nodes. |
| View Answer Report Discuss Too Difficult! Search Google |
|
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? |
| a. | When transmission speeds and capacity in a network prohibit frequent refreshing of large tables. |
| b. | When using many nodes with different operating systems and DBMSs and database designs. |
| c. | The application's data can be somewhat out-of-date. |
| d. | All of the above. |
| View Answer Report Discuss Too Difficult! Search Google |
|
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? |
| a. | Data Replication |
| b. | Horizontal Partitioning |
| c. | Vertical Partitioning |
| d. | Horizontal and Vertical Partitioning |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (a).Data Replication
|
