Q19 /20 Which one of the following is not included in the characteristics of a reliable...
Accenture technical mcq question, verified with a worked answer. Free to practise - no sign-up.
/20
Which one of the following is not included in the characteristics of a reliable transaction system?
Show answer & explanation
Reliable transaction systems are defined by the ACID properties: Atomicity, Consistency, Isolation, and Durability. Transparency is not a core characteristic of transaction systems—it relates to system architecture or data visibility, not transaction reliability. Options A, B, and C are all fundamental ACID properties that ensure data integrity and reliability.
Step-by-step Derivation:
Recall the ACID model for transactions:
- Atomicity: All-or-nothing execution; transaction fully commits or fully rolls back
- Consistency: Data moves from one valid state to another; integrity constraints are maintained
- Isolation: Concurrent transactions do not interfere; changes are isolated until commit
- Durability: Once committed, changes persist even after failures
Transparency is not part of ACID. While transparency can refer to system design principles (e.g., hiding implementation details), it is not a defining characteristic of transaction reliability. Therefore, the answer is D.