What is a transaction and what are ACID properties?
- 14 Answers
- 73225 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
Write a query for primary key constraint with identity key word?
Tell me extended events in sql server 2008?
What is the significance of null value and why should we avoid permitting null values?
How to make remote connection in database?
what is package and it uses and how can u call a package
Can we add a cpu to sql server?
Give the query of getting last two records from the table in SQL SERVER?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is difference between delete and truncate commands?
What are various ways to enhance the ssrs report?
How dts is used to extract, transform and consolidate data?
How is a full-text index updated?
List out the differences between the clustered index and non-clustered index in sql server?
When you should use a low fill factor?
What is SQL Server?
