Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78098 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / archana
A transaction is an atomic unit of work that must be
completed in its entirety.The transaction succeeds if it
committed and fails if it is aborted.Transactions have four
essential properties:atomicity,consistency,isolation, and
durability(known as the ACID properties).
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 ? | 72 Yes | 13 No |
Post New Answer View All Answers
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the web service used for reporting services?
What are pages and extents? : SQL Server Architecture
What are the main sources of data?
What are character string data types in ms sql server?
How sql server executes a statement with nested subqueries?
what stored procedure would you use to view lock information? : Sql server administration
What is database architecture? : SQL Server Architecture
Explain DBCC?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
System requirements for sql server 2005 express edition?
What is the use of sign function?
What is coalesce and check constraint in sql server?
What is the purpose of object explorer and its features? : sql server management studio
What is optimization and its types?
