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
Which data type columns are the best candidates for full-text indexing?
What is cdc in sql server?
What are the extra roles available in msdb? : sql server security
Explain what is raid and what are different types of raid levels?
How to grant a permission in ms sql server using "grant execute" statements?
Can you explain what are various ways to enhance the ssrs report?
List the types of recovery model available in sql server?
What is the use of toad or sqldbx.?
What are the functions in sql server?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Does partitioning help performance?
Explain the concept of recursive stored procedure.
What are database states in ms sql server?
Tell me what are the essential components of sql server service broker?
What is a constant or literal in ms sql server?