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
Data and Database Administration Queries that do full table scans should be avoided. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Authorization tables contain highly sensitive data and should be protected by stringent security rules. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Rollback Reprocess transactions Rollforward Switch to duplicate database Rollback Reprocess transactions Rollforward Switch to duplicate database 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 The transaction log includes which of the following? The before-image of a record 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 The after-image of a record The before and after-image of a record The essential data of the record ANSWER DOWNLOAD EXAMIANS APP