IPA IP 2023 Question 66
A question IPA Japan published in 令和5年度 ITパスポート試験 公開問題 問66, translated into English. ITPEC is based on the same exams.
Same question on ITPEC: Apr 2026 Q29 +1 more
Which of the following is the appropriate explanation of commit in transaction processing?
Explanation
The update is confirmed in the database, used when the transaction ends normally — that is commit.
A transaction is a group of updates that must all take effect or none of them, such as taking money from one account and adding it to another. Until the transaction ends, its changes are provisional. When every step has succeeded, commit makes them final and permanent; if something fails, rollback cancels them and returns the database to its state before the transaction began.
Answer (b)
Why not others:
- •(a) — describes an exclusive lock, which blocks other transactions from updating data one transaction is updating
- •(c) — describes rollback, the opposite of commit, used when the transaction fails
- •(d) — describes a join, which combines tables through the columns that relate them
Key rule: A transaction ends in exactly one of two ways: commit on success makes its updates permanent, rollback on failure undoes them all.
Databases · AI-written, may contain errors
This question comes from the past questions IPA Japan publishes, translated into English by ITPEC Practice. ITPEC Practice is an independent study tool and is not affiliated with IPA or ITPEC. See the original paper (PDF) or Report an issue.