ITPEC FE Morning October 2019 Question 30
ITPEC FE Morning October 2019 — Question 30 of 80
Log file (journal file) — stores before-images and after-images of every database update for recovery purposes.
What it records:
- Before-image — value before the update (used for undo/rollback)
- After-image — value after the update (used for redo/roll-forward)
Why not others:
- (a) Backup file — a full copy of the database at a point in time, not a change-by-change history
- (b) Checkpoint file — marks a synchronization point where buffered data is flushed to disk
- (c) Dump file — essentially the same as a backup; a complete export of the database
Key rule: Log file = update history with before/after values → enables transaction recovery (undo + redo).
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 FE past-paper collection or Report an issue.