IPA IP 2025 Question 61
A question IPA Japan published in 令和7年度 ITパスポート試験 公開問題 問61, translated into English. ITPEC is based on the same exams.
Which of the following is an appropriate description concerning a transaction in a DBMS?
Explanation
All or nothing: commit when the whole series succeeds, roll back when it fails partway — a transaction is the unit of processing that a DBMS completes entirely or not at all.
A transaction groups a series of operations, such as debiting one account and crediting another, that must not be left half done. When every operation succeeds, the DBMS commits: the changes are confirmed and become permanent. When one fails partway, the DBMS rolls back: the database is returned to the state it was in before the transaction started. This property is atomicity, the A of ACID.
Answer (c)
Why not others:
- •(a) — copying a database to another and keeping the copies in sync is replication
- •(b) — recording the operations performed on a database in order is logging (the journal), which the DBMS uses for recovery
- •(d) — creating an index on a table and using it when searching speeds up searches; it is not about transactions
Key rule: Transaction = a series of processing that is committed only if all of it succeeds and rolled back to the starting state if any part fails.
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.