Multiple Choice
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
Correct Answer:
Verified
Q9: Resource locking must be carefully planned because
Q10: The security provided by the DBMS often
Q16: Two-phased locking has a growing phase and
Q22: A dirty read happens when one transaction
Q39: Briefly explain the strategy of two-phased locking.
Q55: The transaction boundaries are the essential information
Q56: Which of the following is true about
Q64: A series of actions to be taken
Q66: The situation that occurs when one user's
Q78: Which are more commonly used: implicit or