ITPEC IP April 2024 Question 29
ITPEC IP April 2024 — Question 29 of 100
Commit permanently confirms the updates made by a successfully completed transaction. Until commit, a transaction's changes are provisional and can generally be undone. When all operations finish normally and consistency requirements are satisfied, commit makes the new state durable and concludes the transaction.
Answer (b)
Why not others:
- (a) describes locking or another concurrency-control mechanism that prevents conflicting updates
- (c) describes rollback, which cancels a failed or aborted transaction and restores the prior state
- (d) describes a join, which combines related rows from multiple tables
Key rule: A successful transaction ends with commit to preserve its changes; an unsuccessful transaction uses rollback to undo them. Together they support atomic transaction processing.
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.