Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78540 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / rahul mankumare
Transaction is a unit of program execution that access &
possibly update various data items.
Usually a transaction is initiated lay a user program
written in a high level data manipulation language or
programming language (for eg. sql c# and java) where it is
deliminated by statement or function call s of the from
begin transaction and end transaction
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 ? | 12 Yes | 6 No |
Post New Answer View All Answers
What are trace flags?
What are the types of processing and explain each? : sql server analysis services, ssas
What is the main difference between ‘between’ and ‘in’ condition operators?
What is a constant or literal in ms sql server?
What are the 7 disadvantages to a manual system?
What is the difference between update lock and exclusive lock?
Tell me what is de-normalization and what are some of the examples of it?
What is the size of transaction log file?
What is stored procedures?
What is CTE in SQL
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Define inner join in sql server joins?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is compression - row-level and page-level compression?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
