What do you understand by validation of ACID properties in database te

1.	What do you understand by validation of ACID properties in database testing?
Answer» ACID stands for Atomicity, Consistency, Isolation and Durability. Everything refers to a property of DATABASE transactions. Atomicity – This refers to that the transactions are ATOMIC which means that the result of the transaction can either be a success or a failure and nothing in between. Consistency – This property implies that the state of the database has to remain VALID after the completion of the transactions. Isolation – This implies that the presence of multiple transactions does not hinder each other as well as the state of the database. Durability – This states that post-commit of a transaction, the data should not be lost EVEN if there is a POWER failure.

What do you understand by validation of ACID properties in database testing?

Answer»

ACID stands for Atomicity, Consistency, Isolation and Durability. Everything refers to a property of DATABASE transactions.

Atomicity – This refers to that the transactions are ATOMIC which means that the result of the transaction can either be a success or a failure and nothing in between.
Consistency – This property implies that the state of the database has to remain VALID after the completion of the transactions.
Isolation – This implies that the presence of multiple transactions does not hinder each other as well as the state of the database.
Durability – This states that post-commit of a transaction, the data should not be lost EVEN if there is a POWER failure.