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 A shared lock allows which of the following types of transactions to occur? Delete Insert Read Update Delete Insert Read Update ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following could cause data to be unavailable? All of these Data becoming lost or inaccurate The database server Planned database maintenance activities All of these Data becoming lost or inaccurate The database server Planned database maintenance activities ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A traditional data administrator performs which of the following roles? Resolve data ownership issues Tune database performance Protect the security of the database Establish backup and recovery procedures Resolve data ownership issues Tune database performance Protect the security of the database Establish backup and recovery procedures ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration The transaction log includes which of the following? 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 The before and after-image of a record ANSWER DOWNLOAD EXAMIANS APP