Question - Explain ACID properties
Answer -
ACID properties are some basic rules, which has to be satisfied by every transaction to preserve the integrity. These properties and rules are:
- ATOMICITY: Atomicity is more generally known as ?all or nothing rule.' Which implies all are considered as one unit, and they either run to completion or not executed at all.
- CONSISTENCY: This property refers to the uniformity of the data. Consistency implies that the database is consistent before and after the transaction.
- ISOLATION: This property states that the number of the transaction can be executed concurrently without leading to the inconsistency of the database state.
- DURABILITY: This property ensures that once the transaction is committed it will be stored in the non-volatile memory and system crash can also not affect it anymore.