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
How to move database physical files in ms sql server?
Explain forward - only cursors?
What is an execution plan? When would you use it?
How to display a past time in days, hours and minutes?
Which rendering formats are affected by the pagesize properties?
How to list all objects in a given schema?
What is microsoft sql server?
What is system stored procedures?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Are resultset updatable?
What is difference between after and before?
Can we use where clause in union?
How many types of attribute relationships are there? : sql server analysis services, ssas
what are the disadvantages of cursors? : Sql server database administration
What is constraints and its types?