Consider a Transaction That Updates Each of the 100 Employees

question 45

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

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

---

Definitions:

Organization

A systematic arrangement of people and resources managed to accomplish a collective goal or set of goals.

Vice President

A senior-level executive in an organization, typically responsible for overseeing specific departments or operations.

Sales Staff

Employees of a business dedicated to selling products or services and interacting with customers to achieve sales goals.

Negotiate

The process of discussing and arriving at a mutual agreement between parties with differing needs or opinions.