ITPEC IP April 2025 Question 29
ITPEC IP April 2025 — Question 29 of 100
A log records the database's transaction history — the recorded information supports recovery and auditing.
A transaction log stores events associated with database changes, often including information needed to redo committed work or undo incomplete work after a failure. This is distinct from the commands and controls that finalize, reverse, or coordinate transactions.
Answer (d)
Why not others:
- (a) defines rollback but labels it commit; commit makes successful changes permanent
- (b) defines commit but labels it exclusive control
- (c) describes concurrency or exclusive control; rollback instead restores changes from an unsuccessful transaction
Key rule: Commit confirms, rollback reverses, concurrency control prevents conflicting simultaneous access, and the log records history for recovery.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.