MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 31 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The purpose of timestamping is to avoid the use of locks.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 2. |
The problem of concurrency control is more complex in a distributed database.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
With asynchronous technology, if any copy of a data item is updated anywhere on the network, the same update is immediately applied to all other copies or it is aborted.~! |
| A. | True |
| B. | False |
| Answer» C. | |
| 4. |
A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
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.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 8. |
The semijoin approach saves network traffic.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 9. |
Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
Each site (or node) in a distributed system is subject to the same types of failure as in a centralized system.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 13. |
Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 14. |
Data replication is favored where most process requests are read-only and where the data are relatively static.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 15. |
With failure transparency, all of the actions of a transaction are committed or none of them are committed.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 16. |
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 |
| Answer» B. Horizontal Partitioning | |
| 17. |
Which of the following is not one of the stages in the evolution of distributed DBMS?%! |
| A. | Unit of work |
| B. | Remote unit of work |
| C. | Distributed unit of Work |
| D. | Distributed request |
| Answer» B. Remote unit of work | |
| 18. |
*$_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 |
| Answer» B. Horizontal Partitioning | |
| 19. |
*$_Which of the following is not one of the stages in the evolution of distributed DBMS?? |
| A. | Unit of work |
| B. | Remote unit of work |
| C. | Distributed unit of Work |
| D. | Distributed request |
| Answer» B. Remote unit of work | |
| 20. |
*$_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. |
| Answer» E. | |
| 21. |
*/*_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. |
| Answer» D. All of the above. | |
| 22. |
*/*_A distributed database can use which of the following strategies?? |
| A. | Totally centralized at one location and accessed by many sites |
| B. | Partially or totally replicated across sites |
| C. | Partitioned into segments at different sites |
| D. | All of the above |
| Answer» E. | |
| 23. |
%_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. |
| Answer» D. All of the above. | |
| 24. |
%_A distributed database can use which of the following strategies?_% |
| A. | Totally centralized at one location and accessed by many sites |
| B. | Partially or totally replicated across sites |
| C. | Partitioned into segments at different sites |
| D. | All of the above |
| Answer» E. | |
| 25. |
%_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 |
| Answer» E. | |
| 26. |
__A homogenous 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. |
| Answer» C. A different DBMS is used at each location and data are not distributed across all nodes. | |
| 27. |
__Which of the following is a disadvantage of replication?__ |
| A. | Reduced network traffic |
| B. | If the database fails at one site, a copy can be located at another site. |
| C. | Each site must have the same storage capacity. |
| D. | Each transaction may proceed without coordination across the network. |
| Answer» D. Each transaction may proceed without coordination across the network. | |
| 28. |
_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 |
| Answer» E. | |
| 29. |
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. |
| Answer» C. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS. | |
| 30. |
A semijoin is which of the following?$? |
| A. | Only the joining attributes are sent from one site to another and then all of the rows are returned. |
| B. | All of the attributes are sent from one site to another and then only the required rows are returned. |
| C. | Only the joining attributes are sent from one site to another and then only the required rows are returned. |
| D. | All of the attributes are sent from one site to another and then only the required rows are returned. |
| Answer» D. All of the attributes are sent from one site to another and then only the required rows are returned. | |
| 31. |
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. |
| Answer» B. The same DBMS is at each node and a central DBMS coordinates database access. | |