ACID properties in transaction management in DBMS stands for :

Join Our Telegram Channel

Atomicity, Concurrency, Isolation, Durability

Autonomy, Consistency, Isolation, Durability

Atomicity, Consistency, Isolation, Durability

Atomicity, Consistency, Infidelity, Durability

Answer is Right!

Answer is Wrong!

This question was previously asked in

UPSC CISF-AC-EXE – 2023

Download PDF Attempt Online

In the context of database transaction management, ACID is an acronym that stands for Atomicity, Consistency, Isolation, and Durability. These are a set of properties that guarantee reliable processing of database transactions. All four properties are essential to ensure data integrity and reliability.

– ACID is a core concept in DBMS transaction management.
– It stands for Atomicity, Consistency, Isolation, and Durability.

– Atomicity: A transaction is treated as a single, indivisible unit. Either all its operations are completed successfully, or none of them are (it’s rolled back).
– Consistency: A transaction must bring the database from one valid state to another, maintaining all defined rules and constraints.
– Isolation: Multiple transactions occurring concurrently must not interfere with each other. The result should be the same as if they were executed sequentially.
– Durability: Once a transaction is committed, its changes are permanent and will survive system failures (like power loss or crashes).

More similar MCQ questions for Exam preparation:-