Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee)under the deferred update mode.The transaction terminates abnormally after the new values of 10 rows have been written to the log.What should the recovery procedure perform to make sure the transaction completes as desired?
A) Execute the transaction again
B) Redo followed by execution of the transaction again
C) Undo
D) Undo followed by execution of the transaction again

Question

Quizplus · Accepted Answer

The Answer of Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee)under the deferred update mode.The transaction terminates abnormally after the new values of 10 rows have been written to the log.What should the recovery procedure perform to make sure the transaction completes as desired?
A) Execute the transaction again
B) Redo followed by execution of the transaction again
C) Undo
D) Undo followed by execution of the transaction again

Consider a Transaction That Updates Each of the 100 Employees