What are ACID properties?

Answer Posted / pallis

Atomicity
The entire sequence of actions must be either completed or aborted. The transaction cannot be partially successful.
Consistency
The transaction takes the resources from one consistent state to another.
Isolation
A transaction's effect is not visible to other transactions until the transaction is committed.
Durability
Changes made by the committed transaction are permanent and must survive system failure.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is the internet a database?

497


Is a server a database?

491


When does checkpoint occur in dbms?

604


What is data modelling techniques?

425


Explain what are tp-lite and tp-heavy monitors?

510






What are five advantages of a database?

470


What is index hunting and how does it help in improving query performance?

1484


How many number of columns can a RECORD GROUP have ?

1583


What are the steps in creating a database?

476


What is vacuum in database?

487


Which database is best for large data?

490


What is the best database software?

505


why an information gap exists in most organizations.

527


Mention the differences between trigger and stored procedures

512


What is db dialect?

576