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
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is transact-sql language?
Where can you find the error log information? : sql server database administration
Explain what stored procedure sp_replcounters is used for? : sql server replication
What are the different methods available under sqlcommand class to access the data?
What are the types of stored procedures in an sql server?
How to configure odbc dsn with different port numbers?
How do I view a trc file?
What is 1nf 2nf and 3nf?
what is denormalization? : Sql server database administration
what's new in sql server 2016?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What happens if null values are involved in string operations?
how to do partition in sqlserver
Explain the concepts and capabilities of sql server?
