ITPEC FE Morning April 2020 Question 30
Source exam: ITPEC FE Morning April 2020Topic: Databases
ITPEC FE Morning April 2020 — Question 30 of 80
Roll back — undo uncommitted changes after the last commit.
- •Roll back — reverts all changes made by transactions since the last commit
- •Roll forward (redo) — reapplies committed changes from the log during recovery
Why not others:
- (a) Commit — saves changes permanently, the opposite of undoing
- (c) Roll forward — replays committed transactions during crash recovery
- (d) View — a virtual table defined by a query, unrelated to transaction control
Key rule: Roll back = undo uncommitted; Roll forward = redo committed (during 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 FE past-paper collection or Report an issue.