Recovering a database via rollback involves:
A) restoring the database from the save and reprocessing all the transactions since the save.
B) restoring the database from the save and reapplying all the changes made by transactions since the save.
C) undoing the changes made by erroneous or partially processed transactions and restarting the valid transactions that were in process at the time of the failure.
D) re-creating the database by re-entering all of the data from the beginning and,then reprocessing all of the transactions.
E) synchronizing the database and the transaction log by checkpointing.
Correct Answer:
Verified
Q84: Explain the concept of an atomic transaction.
Q85: Explain the importance of documenting changes in
Q88: Briefly define the three problems that can
Q92: Which of the following is not true
Q93: Which of the following is not true
Q95: Recovering a database via reprocessing involves:
A)restoring the
Q97: Once processing rights have been defined,they may
Q98: Which of the following would a DBA
Q101: Explain the purpose of transaction logs and
Q102: Discuss the DBMS security model.
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents