1. The transaction log includes which of the following?
2. Which of the following could cause data to be unavailable?
3. A shared lock allows which of the following types of transactions to occur?
4. Locking may cause which of the following problems?
5. Performance analysis and tuning is which of the following?
6. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
7. Which of the following is true concerning open-source DBMS?
8. Concurrency control is important for which of the following reasons?
9. Which of the following is the preferred way to recover a database after a system failure?
10. A data warehouse administrator is concerned with which of the following?
11. To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.
12. Failure to control confidentiality may lead to loss of competitiveness.
13. Authorization tables contain highly sensitive data and should be protected by stringent security rules.
14. A transaction log shows before and after images of records that have been modified by transactions.
15. The greatest threat to business security is often internal rather than external.
16. Information repositories are replacing data dictionaries in many organizations.
17. Mirrored databases are almost always provided in high-availability systems.
18. Databases are not the property of a single function or individual within the organization.
19. Queries that do full table scans should be avoided.
20. The restore/rerun technique involves reprocessing the day's transactions up to the point of failure.
21. Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.
22. A disaster recovery plan does not need to include the shipment of database backups to other sites.
23. With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.
24. Data modeling and database design are key responsibilities of data and data base administration.