Data and Database Administration The transaction log includes which of the following? The before-image of a record The after-image of a record The essential data of the record The before and after-image of a record The before-image of a record The after-image of a record The essential data of the record The before and after-image of a record ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is the preferred way to recover a database after a system failure? Rollback Reprocess transactions Rollforward Switch to duplicate database Rollback Reprocess transactions Rollforward Switch to duplicate database ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Locking may cause which of the following problems? Deadlock Versioning All of these Erroneous updates Deadlock Versioning All of these Erroneous updates ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is part of an administrative policy to secure a database? Ensure appropriate responses rates are in external maintenance agreements Authentication policies Limiting particular areas within a building to only authorized people All of these Ensure appropriate responses rates are in external maintenance agreements Authentication policies Limiting particular areas within a building to only authorized people All of these ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A transaction log shows before and after images of records that have been modified by transactions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A disaster recovery plan does not need to include the shipment of database backups to other sites. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS