Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the difference between substr and charindex in the sql server?
Is it possible to update the views? If yes, how, if not, why?
What are transactions and its controls?
What are the different types of lock modes in sql server 2000?
How to populate a table in sql server?
How sql server enhances scalability of the database system?
Define compound operators?
Where the sql logs gets stored? : sql server database administration
How to search for a string in all stored procedure in sql server?
What have included columns when we talk about sql server indexing?
What is 'Join' and explain its various types.
what is an index? : Sql server database administration
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Explain the working of sql privileges?
What is server-level principal?
