Define ACID Database Properties




Asked on July 30, 2015
Define ACID database properties in short but clear.


Replied on July 30, 2015
A- ATOMIC : Atomic transactions are either completely get success or completely failed. 

C- CONSISTENCY : Data is inserted obeying the constrains applied on the database tables strictly.

I- ISOLATION : If more than one transaction need to happen concurrently, they are executed without affecting other transaction execution. It can be in an order but order can not be predicted. 

D- DURABILITY : Once transaction is executed completely data is saved even after crash or power failure.


A database must follow ACID property.


Write Answer










©2024 concretepage.com | Privacy Policy | Contact Us