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:

Forged Check

A forged check is a check that has been illegally altered or signed by someone other than the account holder, without authorization.

Bank Notification

A notification sent by a bank to its customers regarding updates, transactions, policies, or any other important information.

Litigation

Litigation is the process of taking a dispute to a court of law to be resolved through a lawsuit, including all the proceedings involved from filing to trial.

Stop-Payment Order

An instruction given to a bank by an account holder not to pay a specific check or payment that has been issued but not yet processed.