ITPEC IP April 2022 Question 26
ITPEC IP April 2022 — Question 26 of 100
A rollback cancels an unsuccessful transaction and restores the database to its state before that transaction began. A transaction must behave atomically: either all of its updates take effect or none do. If processing fails before completion, rollback undoes its partial changes so the database is not left in an inconsistent intermediate state.
Answer (c)
Why not others:
- (a) describes locking for concurrency control
- (b) describes commit, which makes a successful transaction's changes permanent
- (d) describes joining relational tables by matching related columns
Key rule: Commit finalizes a successful transaction; rollback reverses an incomplete or failed transaction.
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.