Consider a Transaction That Updates Each of the 100 Employees

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 after a checkpoint but before a system failure.The system crashes after the checkpoint.What should the recovery procedure perform to make sure the transaction completes as desired?

A) Nothing
B) Redo forward from checkpoint
C) Undo
D) Undo followed by execution of the transaction again