Explain ACID properties
Filed under Mastercard ยท Also reported at Cloudera, MindTickle
Free read 3 of 3ACID is a set of guarantees for a transaction, a unit of work that groups multiple operations: Atomicity, Consistency, Isolation and Durability.
The question
Explain the ACID properties of database transactions.
Approach
ACID is a set of guarantees for a transaction, a unit of work that groups multiple operations: Atomicity, Consistency, Isolation and Durability.
Atomicity: all operations succeed or none do (a transfer cannot debit without crediting). Consistency: a transaction takes the database from one valid state to another, respecting constraints and rules.
Isolation: concurrent transactions do not see each other's partial work, controlled by isolation levels (read uncommitted, read committed, repeatable read, serializable). Durability: once committed, data survives crashes, typically via write-ahead logging.
Bank transfer of 100 from A to B shows all four. Stronger isolation reduces anomalies (dirty, non-repeatable and phantom reads) but costs throughput; many NoSQL systems relax ACID for scale (BASE).
Tips
- What they are testing: Use the bank transfer example and name the four letters in order.
- Common mistake: Mixing up consistency in ACID with consistency in CAP, or defining isolation as 'transactions run one at a time'.
Related Mastercard questions
Collected from public candidate posts and coding forums. Updated Nov 2026.