問77
頻出度★☆☆
トランザクション処理の ACID 特性に関する記述として, 適切なものはどれか。
令和4年度 ITパスポート試験 問77
テクノロジ系データベース › トランザクション処理
This question's explanation and your answers so far.
解説
問 77
Incorrectア
This is about preparing an index to improve search speed — a description concerning database search performance. It has nothing to do with the ACID properties of a transaction.
- イ
正解 The “A” in the ACID properties, Atomicity, is the property of controlling a series of operations within a transaction so that they are either “all executed” or “not executed at all,” leaving no half-finished intermediate state. Choice イ states exactly this all-or-nothing idea and is a correct description of atomicity. Therefore イ is appropriate.
Incorrectウ
This describes distributing replicas of the database across multiple servers to improve availability — so-called replication or redundancy. It is a measure for improving availability, not a description of the ACID properties.
Incorrectエ
This describes the effect of normalization — normalizing tables to prevent inconsistencies or duplication in data. It is a database design technique, a concept separate from the ACID properties of a transaction.
ここがポイント
- The ACID properties are four: Atomicity, Consistency, Isolation, and Durability. They are the properties that let a transaction be treated as a reliable unit.
- Atomicity is the property that keeps the operations within a transaction as “all executed or all canceled” (all-or-nothing). If it fails partway, a rollback returns it to the state before execution.
用語