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

Define a cross join?

591


What is the Control Flow in SSIS

570


Does sql server use t sql?

522


How do you create a data source?

466


What are the properties of the transactions?

608






What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

589


how would you troubleshoot blocking? : Sql server database administration

516


Why main is user defined function?

563


how you can get the list of largest tables in a database? : Sql server administration

546


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1551


What is an active database?

592


What are the different normalization forms?

607


Tell me can we use custom code in ssrs?

588


What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

548


What is the correct order of the logical query processing phases?

521