Bird
0
0

In a distributed database, which ACID property is hardest to guarantee and why?

hard📝 Conceptual Q9 of 15
SQL - Transactions and Data Integrity
In a distributed database, which ACID property is hardest to guarantee and why?
ADurability, because network failures can lose data
BAtomicity, because coordinating commits across nodes is complex
CIsolation, because concurrent access is easier to control
DConsistency, because data rules are simpler to enforce
Step-by-Step Solution
Solution:

  1. Step 1: Understand distributed transaction challenges

    Atomicity is hard because all nodes must commit or rollback together.

  2. Step 2: Evaluate other properties

    Durability is manageable with logs, Isolation is complex but less than atomicity, Consistency depends on rules.

  3. Final Answer:

    Atomicity, because coordinating commits across nodes is complex -> Option B

  4. Quick Check:

    Hardest ACID in distributed = B [OK]
Quick Trick: Atomicity hardest in distributed systems [OK]
Common Mistakes:
  • Choosing durability as hardest
  • Underestimating atomicity complexity

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Query Patterns - Conditional aggregation pattern - Quiz 6medium Common Table Expressions (CTEs) - CTE as readable subquery replacement - Quiz 2easy Common Table Expressions (CTEs) - Multiple CTEs in one query - Quiz 3easy Indexes and Query Performance - When indexes help and when they hurt - Quiz 1easy Indexes and Query Performance - Composite index and column order - Quiz 13medium Indexes and Query Performance - CREATE INDEX syntax - Quiz 1easy Triggers - UPDATE trigger with OLD and NEW - Quiz 11easy Window Functions Fundamentals - NTILE for distribution - Quiz 13medium Window Functions Fundamentals - RANK and DENSE_RANK difference - Quiz 1easy Window Functions Fundamentals - ROW_NUMBER function - Quiz 10hard