Consider a Transaction That Updates Each of the 100 Employees

question 66

Multiple Choice

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

---

Definitions:

Negligence

A failure to exercise the care that a reasonably prudent person would exercise in similar circumstances, leading to causing harm or damage.

Battery

An intentional unconsented physical contact or use of force against another person, causing harm or offense.

Self-Defense

The right to defend oneself or others against physical harm or death through the use of reasonable force.

Defense Of Property

The use of reasonable force to protect one's property from harm threatened by another. The use of deadly force in defending one's property is seldom justified.