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

Explain what is log shipping?

832


Tell me what is log shipping?

764


What are the steps you should follow to start sql server in single-user mode?

681


What is raid and what are different types of raid levels?

798


How do you drop an index?

692


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2209


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

761


Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

708


Can you explain what is sql server english query?

737


How do you clear a log file?

721


What are the recovery models in sql server 2000?

723


Do you know what are various aggregate functions that are available?

725


Is mysql better than sql server?

749


What is de-normalization in sql database administration? Give examples?

727


query processing

1931