Q. What are Database ACID properties and their full form?

Answer:-
 Database ACID properties are:
A-Atomocity
C-Consistency
I-Isolation
D-Durability

Atomicity-Atomicity refers to the ability of the database to guarantee that either all of the tasks of a transaction are performed or none of them are.

Consistency-The consistency property ensures that the database remains in a consistent state before the start of the transaction and after the transaction is over (whether successful or not).

Isolation-Isolation refers to the requirement that other operations cannot access or see the data in an intermediate state during a transaction.


Durability-Durability refers to the guarantee that once the user has been notified of success, the transaction will persist, and not be undone. This means it will survive system failure, and that the database system has checked the integrity constraints and won't need to abort the transaction. 

0 comments:

Post a Comment