What is a transaction and what are ACID properties?
- 14 Answers
- 75012 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / hloni
A transaction is a sequence of database operations that
access the database. It must be a logical unit of work,
meaning that no portion of the transaction can exist on its
own. Either all parts are executed or the transaction is
aborted.
Transaction has five main properties called ACIDS:
1. Atomicity -- all parts of the transaction are executed
or else the transaction is aborted.
2. Consistency -- indicates the permanence of the
database's consistent state. When a transaction is
completed the database reaches a consistence state.
3. Isolation -- means that the data used during the
exercution of a transaction cannot be used by the a second
transaction until the first transaction is complete.
4. Durability -- ensures that once transaction changes are
commited, they cannot be lost even in the event of system
failure.
5. Serializability -- ensures that concurrent execution of
several transaction yields consistent results. This
property is important in a multi-user and distributed
datbases, where multiple transaction are likely to be
executed concurrently.
| Is This Answer Correct ? | 14 Yes | 10 No |
Post New Answer View All Answers
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What do you mean by a Composite primary key?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
How to create and drop temp table in sql server?
What languages bi uses to achieve the goal?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Which are new data types introduced in sql server 2008?
How to drop existing views from a database in ms sql server?
What is database mirroring?
How to execute function in stored procedure sql server?
Explain about extended stored procedure?
Characterize join and name diverse sorts of joins?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What do you mean by an execution plan?
Explain can SSRS reports Cache results?
