Answer Posted / rahul mankumare
Atomicity:The work cannot be broken into smaller
parts.Although a transaction might contain many SQL
statements,it must be run as all-or-nothing
proposition,which means that,if a transaction is only
partially complete when an error occurs,the work revertss
to its state prior to the start of the transaction.
Consistency:A transaction must operate on a consistent view
of the data and also leave the data in a consistency
state.Any work in progress must not be visible to other
transactions until the transaction has been committed.
Isolation:A transaction should appear to be running by
itself,the effects of other ongoing transactions must be
invisible to this transaction,and the effects of this
transaction must be invisible to other ongoing transaction.
Durability:When the transaction is committed,it must be
persisted so it is not lost in the event of a power
failure.Only committed transaction are recovered during
power-up and crash recovery;uncommitted work is roll back.
| Is This Answer Correct ? | 32 Yes | 6 No |
Post New Answer View All Answers
Explain concepts of analysis services?
How we can refresh the view?
How many non clustered indexes there can be on table ?
What are the new features of sql server 2008 r2 reporting service?
Difference between connected and disconnected database in .net with sql server?
What is a trigger in sql server?
What are the differences between web role and worker role?
Why do we need different type of parameter?
How we can compare two database data?
Explain an automatic checkpoint
What is parameterized reports in ssrs ?
When would you use it?
What is a select query statement in ms sql server?
What are different type of Collation Sensitivity?
What do you understand by a view?
