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:

Schizophrenia

A chronic brain disorder characterized by distorted thinking, perceptions, emotions, language, self-awareness, and behavior.

Temporal Lobes

Regions of the cerebral cortex located beneath the temples, involved in processing auditory information and crucial for memory, speech, and recognizing faces.

Motor Cortex

The part of the cerebral cortex that plays a crucial role in the planning, control, and carrying out of voluntary movements.

Frontal Lobe

The part of the human brain located behind the forehead, associated with reasoning, planning, parts of speech, movement, emotions, and problem-solving.