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
How you can move data or databases between servers and databases in sql server?
What is Replication?
How do I create a trace in sql server?
Write a program to fetch first 10 records from a file?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What is 3nf normalization?
How to copy data from one table to another table?
What are the difference between primary keys and foreign keys?
What new data source types were added in ssrs 2014?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are the different editions available in sql server 2000?
What is the syntax for encrypting a column in SQL Server?
What are the different types of locks in the database?
Tell me what is difference between clustered and non clustered index?
What are the new security features added in sql server 2012? : sql server security
