Home » Interview Q & A » Q8. What are ACID properties?

Q8. What are ACID properties?

Our Categories

Blog Stats

  • 34,479 hits

Calendar

June 2013
M T W T F S S
« May    
 12
3456789
10111213141516
17181920212223
24252627282930

Please visit SQLVERSITY.COM for more details.

The acronym ACID stands for Atomicity, Consistency, Isolation and Durability. These are group of properties that every DBMS must satisfy. Any database is said to be reliable, if it meets all these properties. Otherwise, we consider that DBMS as not reliable.

Atomicity:

All the operations in a transaction will be completed or will not be executed at all.

Consistency:

It ensures that by the end of a transaction, the system will be in a valid state. That means only valid data will be committed.

Isolation:

It ensures that, transactions are processed without interference. That means, one transaction cannot read the data from another transaction until it executes completely.

Durability:

It ensures that a transaction which was committed to the database will be permanent.

For more information about ACID properties, Click here

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: