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
Q75: When a transaction rereads data that has
Q79: The task of diagnosing errors due to
Q81: Which of the following cannot be enforced
Q81: Distinguish between statement-level consistency and transaction-level consistency.
Q86: Explain the concept of serializable transactions.
Q87: Which of the following would not be
Q92: Briefly define the four isolation levels and
Q95: Which are more commonly used: implicit or
Q98: Distinguish between the four cursor types.
Q99: Briefly explain the strategy of two-phased locking.
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