What is ACID property?

Posted By: Avi

Date: 1 October 2010 11:46:07 AM

Answer:

ACID is the acronym for Atomicity,Consistency,Isolation and Durability. Whenever a transaction is executed in SQL server certain characteristics which are to be possessed by the transaction is maintained. ACID are those charactersistics. Atomicity:- By atomicity it is meant that group of T-sql statements will act in a batch. Consistency:- The transaction should act open consistent data and after operation should leave data in consistent form. Isolation:- By isolation it is meant that the running transaction should feel that it is the only one being performed. That is that if there are several transaction being executed then transaction isolation will ensure that each transaction will think that it has exclusive use of the system. Durability:- By transaction Durabity it is meant that any successful completion ofthe transaction should leave it in permanent state,i.e. ther should be no loss of information. Such as committed transactions should persist,even if there is any crash or power faliure.Basically it is the ability of DBMS to recover committed data even after power faliures or system crash.

Posted By: avibtech

Date: 1 October 2010 11:46:07 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

Differentiate between SQL and PL/SQL?

1. SQL is simpleified statement for Selecting and Manipulating the data. Whereas PL/SQL is a Procedu....

Category: Database

Date: 10/1/2010 12:24:08 PM