Multiple Choice
Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the immediate update mode and completes before a checkpoint.The system crashes after the checkpoint.What should the recovery procedure perform to make sure the transaction completes as desired?
A) Nothing
B) Redo followed by execution of the transaction again
C) Undo
D) Undo followed by execution of the transaction again
Correct Answer:

Verified
Correct Answer:
Verified
Q40: When the recovery manager performs a(n)_ operation
Q41: SQL:2003 provides for a SAVEPOINT statement which
Q42: Consider a transaction that updates each of
Q43: The transaction property of being _ means
Q44: Locking Granularity: the size of the database
Q46: To restore a database using the immediate
Q47: One of the advantages of concurrency transparency
Q48: A _is common data that multiple users
Q49: Typically,the most serious concurrency problem to avoid
Q50: With the _ approach,database updates are written