Consider a Transaction That Updates Each of the 100 Employees

question 42

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

---

Definitions:

Deep-cycling

A process of discharging a battery completely before charging it again to maintain its capacity.

Wet Cell

A type of battery containing a liquid electrolyte solution, commonly used in automotive and other applications.

Lead Acid

A type of rechargeable battery technology using lead electrodes and sulfuric acid electrolyte, commonly used in vehicles and backup power systems.