Data and Database Administration Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Rollforward Switch to duplicate database Rollback Reprocess transactions Rollforward Switch to duplicate database Rollback Reprocess transactions ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Information repositories are replacing data dictionaries in many organizations. False True False True 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 Protect the security of the database Establish backup and recovery procedures Tune database performance Resolve data ownership issues Protect the security of the database Establish backup and recovery procedures Tune database performance ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A shared lock allows which of the following types of transactions to occur? Update Delete Read Insert Update Delete Read Insert 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