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 A transaction log shows before and after images of records that have been modified by transactions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration The transaction log includes which of the following? The before and after-image of a record The after-image of a record The essential data of the record The before-image of a record The before and after-image of a record The after-image of a record The essential data of the record The before-image of a record ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Concurrency control is important for which of the following reasons? 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A traditional data administrator performs which of the following roles? Resolve data ownership issues Establish backup and recovery procedures Protect the security of the database Tune database performance Resolve data ownership issues Establish backup and recovery procedures Protect the security of the database Tune database performance ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Backward recovery is which of the following? Where the after-images and before-images are applied to the database 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 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 ANSWER DOWNLOAD EXAMIANS APP