Multiple Choice
A series of actions to be taken on the database such that either all actions are completed successfully,or none of them can be completed,is known as a:
A) checkpoint.
B) log.
C) lock.
D) transaction.
E) concurrent.
Correct Answer:
Verified
Correct Answer:
Verified
Q9: Resource locking must be carefully planned because
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
Q61: Recovering a database via rollback involves:<br>A)restoring the
Q64: A database save is used to mark
Q66: The situation that occurs when one user's
Q66: The DBA should periodically analyze run-time statistics
Q85: Briefly define the three problems that can