Which of the following is not an ACID property of a reliable database system?
Accenture technical mcq question, verified with a worked answer. Free to practise - no sign-up.
Which of the following is not an ACID property of a reliable database system?
Show answer & explanation
Answer: D. Transparency
ACID properties are Atomicity, Consistency, Isolation, and Durability—fundamental guarantees for reliable database transactions. Transparency is not part of ACID; it relates to system visibility or abstraction layers, not transaction reliability. Options A, B, and C are the first three letters of ACID and are all legitimate database properties.
Step-by-step Derivation:
ACID is an acronym:
- A = Atomicity: All-or-nothing execution; transaction either fully completes or fully rolls back.
- C = Consistency: Database moves from one valid state to another; integrity constraints are maintained.
- I = Isolation: Concurrent transactions do not interfere with each other.
- D = Durability: Once committed, data persists even after system failures.
Transparency is not part of this acronym and is not an ACID property. It may relate to data transparency or system design, but it is not a database reliability guarantee.