ACID rules in sql server?

 Posted by aswinialuri-19361 on 3/13/2013 | Category: Sql Server Interview questions | Views: 3173 | Points: 40
Answer:

Atomicity
Consistency
Isolation
Durablity

Atomicity:
Modification on the data in the database either fail or succeed. The beginning of such a modification starts with a transactionand ends when a transaction finishes (either by a commit or arollback). A software crash entails an implicit rollback.
Consisyency:
Modification on the data in the database either fail or succeed. The beginning of such a modification starts with a transactionand ends when a transaction finishes (either by a commit or arollback). A software crash entails an implicit rollback.

Isolation:
One transaction does not interfere with another. The 'executor' of a transaction has the feeling that he has the entire database for himeself.
Durablity:
A commited transaction will not be lost.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Raja_89 on: 3/15/2013 | Points: 10
ACID
It is a set of properties that guarantees the transactions in DBMS
A tomicity
Either all or nothing.
It tells the transactions state either Fails or Sucess.
Even though a part of a transaction is failed it results in fails

Consisyency:
Wheather the data was was sastisfied before entering the database
I solation
It involves the concurrent execution of transactions results in a system state that would be obtained if transactions was executed serially

D urability
Once a transaction has committed,it will remain so, even when the power loss .









Login to post response