What does the ACID properties guarantee in a database transaction?
2024
What does the ACID properties guarantee in a database transaction?
- A.
Atomicity, Consistency, Isolation, Durability
- B.
Availability, Confidentiality, Integrity, Data Independence
- C.
Access Control, Integrity, Distribution, Security
- D.
None of the above
Attempted by 171 students.
Show answer & explanation
Correct answer: A
The ACID properties guarantee reliable database transactions through four key principles: Atomicity ensures all-or-nothing execution, Consistency maintains data integrity rules, Isolation prevents concurrent transaction interference, and Durability guarantees committed changes persist permanently.