What is ACID Property of Transaction?

Answer Posted / vishal

Atomicity means either the transaction is complete or it it will go on its previous condition
consistency :- it means that after and before the transaction process the data remains in consistent manner;
Isolation :- if two transaction process than each transaction is unaware to both of them
Durability :-means when the transaction is committed .it must be durable even the system is crash..

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between count (*) and count column?

533


Which tcp/ip port does the sql server run on? How can it be changed?

541


What are difference between Cluster index and Non-Cluster index?

618


How we create SQL Server 2005 Reporting Services ? Give me Sample

1581


Do you know what is replace and stuff function in sql server?

480






What should be the fill factor for indexes created on tables? : sql server database administration

633


Why use identity in sql server?

574


What are the elements of dbms?

558


What are types of scd? : sql server analysis services, ssas

546


Explain logical operators in sql server?

578


How to test odbc dsn connection settings?

544


Explain the concept of recursive stored procedure.

502


do views contain data ?

594


Can binary strings be used in arithmetical operations?

530


Explain nested trigger in sql?

601