IPA FE Subject A 2023 Question 7
A question IPA Japan published in 令和５年度 基本情報技術者試験 科目A 公開問題 問7, translated into English. ITPEC is based on the same exams.
Same question on ITPEC: Oct 2024 Q22
Which of the following is a property on a database that guarantees a result where a transaction either fully completes update processing or is revoked as if no processing took place at all?
Explanation
Atomicity — the all-or-nothing property of a transaction, one of the four ACID properties.
A transaction's updates are treated as one indivisible unit: either every update is committed, or, if anything fails, all of them are rolled back so the database looks as if the transaction never ran. That is exactly the guarantee the question describes.
Answer (a)
Why not others:
- •(b) Consistency — guarantees a transaction takes the database from one valid state to another, keeping integrity constraints; it says nothing about partial completion
- •(c) Durability — guarantees that once a transaction commits, its results survive later failures
- •(d) Isolation — guarantees that concurrent transactions do not see each other's intermediate results, as if they ran one after another
Key rule: ACID: Atomicity = all or nothing, Consistency = valid state to valid state, Isolation = no interference between concurrent transactions, Durability = committed results are permanent.
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.