What is a transaction and what are ACID properties?
- 14 Answers
- 75015 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 is the name of the Database which IBM mainframe uses?
What is use of dbcc commands?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
what are the types of indexes? : Sql server database administration
What is difference between line feed ( ) and carriage return ( )?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is the tcp/ip port on which sql server runs?
What is ddl and dml commands?
What is factless fact table? : sql server analysis services, ssas
Does sql server use t sql?
Explain “not null constraint” in sql server?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How to create an inline table-valued function?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Detail about the hardware which is supported by SQL server?
