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 a sql join?
What is the difference between count () and rowcount ()?
What is the difference between for xml raw and for xml auto?
Do you know what are the ways available in sql server to execute sql statements?
What are the different types of replication are there in sql server 2000?
What are “lost updates”?
What do you mean by tablesample?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Mention the different authentication modes in sql server.
in the physical file layout, where should the transaction log be stored in relation to the data file?
How adventureworkslt tables are related?
What is the use of commit?
Where are full-text indexes stored?
If the job running very slow what is the action you do
what is the system function to get the current user's user id? : Sql server database administration