Multiple Choice
Recovering a database via rollforward 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
Q16: Which of the following cannot be enforced
Q18: Which of the following is not true
Q22: Measures that are taken to prevent one
Q65: The DBA has to find a balance
Q71: Reprocessing is normally the most convenient method
Q77: Copies of each database record or page
Q79: When a transaction rereads data that has
Q88: Two-phased locking is a scheme for achieving
Q89: Database administration tasks have to be performed
Q97: A transaction is a group of alternative