ITPEC IP October 2019 Question 26
ITPEC IP October 2019 — Question 26 of 100
Rollback cancels an unsuccessful transaction and restores the database to its state before that transaction began. Undoing all partial changes preserves transaction atomicity, ensuring that either the complete operation takes effect or none of it does.
Answer (c)
Why not others:
- (a) describes locking for concurrency control
- (b) describes commit, which makes successful changes permanent
- (d) describes joining related tables
Key rule: Commit finalizes a successful transaction; rollback reverses its uncommitted changes after failure or cancellation.
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.