Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is indexing in database with example?

911


What is the most used database?

914


What is cold backup, hot backup, warm backup recovery?

774


What are notification services?

923


How many types of database language exist?

974


What is the meaning of flat file database?

943


Explain the concepts of a primary key and foreign key.

828


What is data abstraction in dbms?

986


Why do we need database?

858


What is limit in dbms?

965


How many types of relationship exist in database designing?

855


What is a functional dependency in the dbms?

855


What is dba in dbms?

969


What do you understand by intension and extension?

858


Explain the term entity in dbms?

855