wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform



wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is..

Answer / praveen

Transaction must be Atomic (it is one unit of work and does
not dependent on previous and following transactions)

Consistent (data is either committed or roll back, no
“in-between” case where something has been updated and
something hasn’t)

Isolated (no transaction sees the intermediate results of
the current transaction)

Durable (the values persist if the data had been committed
even if the system crashes right after).

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How do I create an extended event in sql server?

0 Answers  


What are various ways to enhance the ssrs report?

0 Answers  


How to write a query with a left outer join in ms sql server?

0 Answers  


What is an indexing strategy?

0 Answers  


Different Types of Functions ?

2 Answers   Satyam,






How can we write or define DDL statements in Sql server and DML statements?

3 Answers  


How do I determine how many instances of sql server are installed on a computer?

0 Answers  


How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,


Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,


How many types of the database links?

0 Answers   MCN Solutions,


Why is DML provided?

1 Answers   Ernst Young, Thomson Reuters,


Give main differences between "Truncate" and "Delete".

0 Answers   HCL,


Categories