Consider a Transaction That Updates Each of the 100 Employees

question 11

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.The transaction terminates abnormally after 10 rows have been updated in the database (and the normal operations have taken place on the log) .What should the recovery procedure perform to make sure the transaction completes as desired?

• A) Redo
• B) Redo followed by execution of the transaction again
• C) Undo
• D) Undo followed by execution of the transaction again

---

Definitions:

Cycle Time

The total time from the beginning to the end of a process, including process time and any delays, indicating the speed at which outputs are produced from inputs.

Workstations

Designated areas in a manufacturing or office setting where specific tasks are performed, often outfitted with necessary tools and equipment.

Task Times

The duration required to complete specific jobs or assignments in a production or work process.

Assembly Line

A production process that breaks down the manufacture of a product into steps that are completed in a pre-defined sequence, often on a conveyor belt, to increase efficiency.