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
Correct Answer:

Verified
Correct Answer:
Verified
Q3: Which type of lock still allows other
Q4: Which of the following is not true
Q5: One remedy for the inconsistencies caused by
Q6: Ensuring that all rows impacted by the
Q7: Which of the following would a DBA
Q9: Resource locking must be carefully planned because
Q10: The security provided by the DBMS often
Q11: According to ANSI SQL,the serializable isolation level
Q12: In general,optimistic locking is the preferred technique
Q13: Resource locking is one remedy to the