ACID properties in transaction management in DBMS stands for :

[amp_mcq option1=”Atomicity, Concurrency, Isolation, Durability” option2=”Autonomy, Consistency, Isolation, Durability” option3=”Atomicity, Consistency, Isolation, Durability” option4=”Atomicity, Consistency, Infidelity, Durability” correct=”option3″]

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:-