Question

What are the ACID properties?

Answer 1

1. The acronym stands for Atomicity, Consistency, Isolation and Durability. Atomicity follows the thumb rule “All or Nothing” while updating the data in the database for the user performing the update operation.
2. Consistency ensures that the changes in data value to be constant at any given instance. Isolation property is needed during concurrent action.
3. Durability is defined as the system’s ability to recover all committed actions during the failure of storage or the system.