Which one of the following is NOT a part of the ACID properties of database…

20162023

Which one of the following is NOT a part of the ACID properties of database transactions?

  1. A.

    Atomicity

  2. B.

    Consistency

  3. C.

    Isolation

  4. D.

    Deadlock-freedom

Attempted by 1314 students.

Show answer & explanation

Correct answer: D

Key idea: ACID describes four core properties of database transactions: Atomicity, Consistency, Isolation, and Durability.

  • Atomicity: the transaction is all-or-nothing; either all its changes are applied or none are.

  • Consistency: a transaction moves the database from one valid state to another, preserving integrity constraints.

  • Isolation: concurrently executing transactions do not interfere with each other; results are as if transactions ran serially.

  • Durability: once a transaction commits, its changes are permanent and will survive system failures.

Deadlock-freedom is not part of ACID; it is a property related to concurrency-control algorithms (how a system avoids or resolves deadlocks) rather than one of the transactional guarantees listed by ACID.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Gate Guidance By Sanchit Sir