New Click here to Enroll in NaBFID Analyst Intro Class on May 6

    Question

    Which of the following is NOT a property of database

    transactions according to the ACID model?
    A Atomicity Correct Answer Incorrect Answer
    B Consistency Correct Answer Incorrect Answer
    C Isolation Correct Answer Incorrect Answer
    D Dependency Correct Answer Incorrect Answer
    E Durability Correct Answer Incorrect Answer

    Solution

    The ACID properties —Atomicity, Consistency, Isolation, and Durability—are fundamental principles that ensure reliable processing of database transactions.

    • Atomicity ensures that a transaction is all-or-nothing: either all its operations are completed, or none are.
    • Consistency guarantees that a database moves from one valid state to another, preserving integrity constraints.
    • Isolation ensures that transactions execute independently, preventing intermediate states from affecting others.
    • Durability ensures that once a transaction is committed, its changes are permanent, even in the event of system failure.
    Dependency is not a recognized property in the ACID framework. While dependencies between transactions may exist in some contexts, they do not form part of ACID's foundational principles. Why Other Options Are Incorrect:
    • Atomicity: Central to ACID; ensures transactions are indivisible units of work.
    •  Consistency: Prevents integrity violations by ensuring valid state transitions.
    •  Isolation: Key to ensuring concurrent transactions do not interfere improperly.
    •  Durability: Protects committed transactions from system crashes.

    Practice Next