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 to select the first record in a given set of rows?

460


Does google have a database program?

488


What are cursors give different types of cursors?

485


What is considered a database?

467


What is rdbms and its features?

531






define aggregate functions.

529


Mention the types of join?

486


Who is the founder of database?

474


How can I join two tables in database?

511


What are the different types of languages that are available in the dbms?

592


When does checkpoint occur in dbms?

601


What does clipper stand for?

516


What is pcbs (program communication blocks)?

527


What are fact tables and dimension tables ? What is dimensional modeling and star schema design

443


Is a database a file?

519