Database - Data and Database Administration
Database - Data and Database Administration
11. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
- Rollback
- Rollforward
- Switch to duplicate database
- Reprocess transactions
12. Which of the following is true concerning open-source DBMS?
- Is free or nearly free database software whose source code is publicly available
- Is free or nearly free database software whose source code is not publicly available
- Is not competitive against PC-oriented packages and is fully SQL compliant
- Is competitive against PC-oriented packages and is not fully SQL compliant
13. Concurrency control is important for which of the following reasons?
- To ensure data integrity when updates occur to the database in a multiuser environment
- To ensure data integrity when updates occur to the database in a single-user environment
- To ensure data integrity while reading data occurs to the database in a multiuser environment
- To ensure data integrity while reading data occurs to the database in a single-user environment
14. Which of the following is the preferred way to recover a database after a system failure?
- Rollback
- Rollforward
- Switch to duplicate database
- Reprocess transactions
15. A data warehouse administrator is concerned with which of the following?
- The time to make a decision but not the typical roles of a database administrator
- The time to make a decision and the typical roles of a database administrator
- The typical roles of a data administrator and redesigning existing applications
- The typical roles of a database administrator and redesigning existing applications