What are ACID properties?

Answer Posted / piyush sharma

ACID refers to the basic properties of a database
transaction: Atomicity, Consistency, Isolation, and
Durability.

All Oracle database, Oracle RDB and InnoDB transactions
comply with these properties. However, Oracle's Berkeley DB
database is not ACID-compliant.

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 ?    64 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you exit a database?

571


Define a relation schema and a relation.

629


Why c++ used in clipper?

569


What is a degree of relation?

637


what are the different levels of database schema?

679






What is database management used for?

585


Why is the use of dbms recommended? Explain by listing some of its major advantages.

1324


How can we tune a oracle database if log file sync issue comes

1756


What is the difference between star flake and snow flake schema?

553


What are the different stages in 'data warehousing'?

556


What is big data database?

574


What is database management system(dbms) and why it is used?

571


Enlist some commands of ddl?

598


Describe concurrency control.

626


Does google have a database like access?

565