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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know hot add cpu in sql server 2008?

544


What is a primary key?

544


Describe triggers features and limitations?

508


How to insert new line characters into strings?

564


What is 2nf example?

554






How to remove duplicate rows from table except one?

576


Why it is recommended to avoid referencing a floating point column in the where clause?

542


Show Practically Sql Server Views are updatable?

594


How to create a ddl trigger using "create trigger" statements?

618


What is report snapshot in ssrs?

166


How to install sql server 2005 express edition?

600


How you can move data or databases between servers and databases in sql server?

571


What is a synonym for manipulation?

554


Do you know how to implement service broker?

539


What is failover clustering overview?

595