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 db context?

975


State three differences between Dbms and Rdbms?

1121


Why is database important?

1104


What do you understand by correlated subqueries in dbms?

1018


What are the limitations of using a model?

1075


What the default privileges which get assigned ?

1002


Why do we need database normalization?

1066


What is the importance of database in an organization?

902


Why is maintaining a database important?

953


What do you understand by sub-queries in sql?

992


Explain the terms ‘attribute’ and ‘relations’

1197


how to generate an auto incremental number in a ssis package?

1064


What are data modelling tools?

976


How to recreate the index on a firebird table?

959


What is database normalization? Explain types of it.

1043