ITPEC IP October 2025 Question 28
ITPEC IP October 2025 — Question 28 of 100
Restore the database to its state before a failed transaction began — this is rollback.
A transaction should be atomic: either all its intended updates succeed or none take effect. If processing fails, rollback undoes the transaction's partial changes so the database does not retain an inconsistent intermediate state.
Answer (c)
Why not others:
- (a) describes locking or exclusive control
- (b) describes commit, which makes successful changes permanent
- (d) describes joining tables through related keys
Key rule: Commit finalizes a successful transaction; rollback reverses an incomplete or failed one.
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.