What does the ACID acronym stand for in database transactions?
a) Accuracy, Concurrency, Isolation, Durability
b) Atomicity, Consistency, Isolation, Durability
c) Accuracy, Consistency, Independence, Data Integrity
d) Authentication, Control, Integrity, Data Management
Answer:
b) Atomicity, Consistency, Isolation, Durability
Explanation:
ACID stands for Atomicity, Consistency, Isolation, and Durability. These are the key properties that guarantee reliable processing of transactions in a database.
Atomicity ensures that all operations within a transaction are completed or none at all. Consistency ensures that the database remains in a valid state after the transaction. Isolation ensures that concurrent transactions do not interfere with each other. Durability ensures that once a transaction is committed, its changes are permanent.
These properties make transactions reliable and secure, particularly in multi-user environments where data integrity is critical.