What is ACID properties of transaction? a. Atomicity, Consistency, Isolation, Database b. Atomicity, Concurrency, Isolation, Database c. Atomicity, Concurrency, Isolation, Database d. Atomicity, Consistency, Isolation, Durabilty code example
Example 1: acid properties in dbms
Atomicity
The entire transaction take place at once or doesn't happen at all.
Consistency
Database must be consistent before and after the transaction.
Isolation
Multiple transactions occur independently without interference.
Durability
The changes of the successful transaction occurs even if the system
failure occur.
Example 2: acid properties
Atomicity
Consistency
Isolation
Durability