nasunilkumar

 Profile Answers by nasunilkumar 

• Mar 20th, 2010

 

ACID properties are
1) Atomicity
2) Consistency
3) Isolation
4) Durability

ushaudayam

 Profile Answers by ushaudayam 

• Mar 22nd, 2010

 

ACID Properties are

Atomicity: A transaction is an atomic unit of execution, which may contain more than one database operation. The transaction should be done entirely or done nothing to keep data in a consistent state.

Consistency: It ensures that the entire transaction takes the database from one consistent state to another consistent state. Even if the transaction fails then also the database should be in consistent state.

Isolation: Updations of a database should not be visible until the transaction is committed.

Durability: Once the transaction is committed the changes made by the transaction should not be lost because of any failure.