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
|