Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Switch to duplicate database Reprocess transactions Rollback Rollforward TRUE ANSWER : ? YOUR ANSWER : ?
To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository. False True TRUE ANSWER : ? YOUR ANSWER : ?
Backward recovery is which of the following? Where the after-images are applied to the database Where the before-images are applied to the database Switching to an existing copy of the database Where the after-images and before-images are applied to the database TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is part of an administrative policy to secure a database? All of these Ensure appropriate responses rates are in external maintenance agreements Authentication policies Limiting particular areas within a building to only authorized people TRUE ANSWER : ? YOUR ANSWER : ?
A transaction log shows before and after images of records that have been modified by transactions. True False TRUE ANSWER : ? YOUR ANSWER : ?
The transaction log includes which of the following? The after-image of a record The before and after-image of a record The essential data of the record The before-image of a record TRUE ANSWER : ? YOUR ANSWER : ?
Mirrored databases are almost always provided in high-availability systems. False True TRUE ANSWER : ? YOUR ANSWER : ?
A disaster recovery plan does not need to include the shipment of database backups to other sites. False True TRUE ANSWER : ? YOUR ANSWER : ?
Failure to control confidentiality may lead to loss of competitiveness. True False TRUE ANSWER : ? YOUR ANSWER : ?