ITPEC FE Morning October 2023 Question 29
ITPEC FE Morning October 2023 — Question 29 of 80
Database Log File — stores before/after values of each update for recovery.
A log file (also called journal file) records every database modification with both the old value (before image) and new value (after image).
Purpose:
- Undo (rollback): restore old values if a transaction fails
- Redo (roll forward): reapply new values after a crash
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 when in-memory data was flushed to disk; does not store field values
- (c) Dump file — essentially a database export/backup, not an incremental update log
Key rule: If the question mentions "values before and after an update" → log file.
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.