Which of the following is NOT one of the fundamental ACID characteristics of a reliable...
Accenture technical mcq question, verified with a worked answer. Free to practise - no sign-up.
Which of the following is NOT one of the fundamental ACID characteristics of a reliable database transaction processing system?
Show answer & explanation
ACID stands for Atomicity, Consistency, Isolation, and Durability—the four core properties of reliable database transactions. Transparency is not part of the ACID model; it refers to a general software principle where internal workings are hidden from users, but it is not a transaction guarantee. Options A, B, and C are all fundamental ACID properties.
Step-by-step Derivation:
ACID Properties Definition:
- A (Atomicity): Transaction is all-or-nothing; either fully commits or fully rolls back.
- C (Consistency): Transaction moves database from one valid state to another, maintaining all integrity constraints.
- I (Isolation): Concurrent transactions do not interfere with each other; each executes independently.
- D (Durability): Once committed, transaction changes are permanent and survive system failures.
Transparency is not an ACID property. The question asks which is NOT a fundamental ACID characteristic, making D the correct answer.