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

Verified
Correct Answer:
Verified
Q82: Locks that are placed assuming that a
Q83: The DBA is responsible for managing changes
Q84: Database administration is more important but less
Q85: Briefly define the three problems that can
Q86: One important reason for documenting changes to
Q88: Two-phased locking is a scheme for achieving
Q89: Database administration tasks have to be performed
Q90: Discuss the DBMS security model.
Q91: A passive data repository is preferred over
Q92: Resources are locked for a shorter amount