What is a transaction and what are ACID properties?
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
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How you can move data or databases between servers and databases in sql server?
Is sql server implemented as a service or an application? : Sql server database administration
What is a cache in ssrs?
What are the types of database schema? : sql server analysis services, ssas
What are the different types of triggers in SQL SERVER?
Describe triggers features and limitations?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
How to test a dml trigger in ms sql server?
Is natural join and equi join same?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How to use values from other tables in update statements in ms sql server?
A trigger can reference objects outside the current database? State true or false.
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What is database mirroring?