ITPEC IP April 2026 Question 29
ITPEC IP April 2026 — Question 29 of 100
Commit permanently confirms a successfully completed transaction's updates — after commit, the database treats the changes as durable.
A transaction groups operations into one logical unit. When all operations succeed, COMMIT finalizes them; if processing fails, ROLLBACK restores the state before the transaction.
Answer (b)
Why not others:
- (a) describes locking for concurrency control
- (c) describes rollback
- (d) describes joining related tables in a query
Key rule: COMMIT keeps successful work; ROLLBACK cancels the transaction's uncommitted work. Together they support transaction atomicity and durability.
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.