Explain ACID property in SQL

Question

Accepted Answer

ACID property ensures that database transactions are processed reliably.

ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that a transaction is treated as a single unit of work, either all or none of its operations are executed.
Consistency ensures that a transaction brings the database from one valid state to another.
Isolation ensures that concurrent transactions do not interfere with each other.
Durability ensures that once a transaction is committed, its changes are permanent and survive any subsequent failures.
For example, if a bank transfer is made from one account to another, ACID properties ensure that the amount is deducted from one account and added to the other account reliably.

Popular interview questions of Technical Lead