Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78537 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / ajith
In computer science, ACID (atomicity, consistency,
isolation, durability) is a set of properties that
guarantee database transactions are processed reliably. In
the context of databases, a single logical operation on the
data is called a transaction. For example, a transfer of
funds from one bank account to another, even though that
might involve multiple changes (such as debiting one
account and crediting another), is a single transaction.
Jim Gray defined these properties of a reliable transaction
system in the late 1970s and developed technologies to
automatically achieve them.[1] In 1983, Andreas Reuter and
Theo Haerder coined the acronym ACID to describe them.[2]
Contents [hide]
1 Characteristics
1.1 Atomicity
1.2 Consistency
1.3 Isolation
1.4 Durability
2 Examples
2.1 Atomicity failure
2.2 Consistency failure
2.3 Isolation failure
2.4 Durability failure
3 Implementation
3.1 Locking vs multiversioning
3.2 Distributed transactions
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the benefit of normalization?
What is the filtered index?
List out the differences between global and local temp tables in sql server?
What is normalization process?
How to get @@error and @@rowcount at the same time?
What are “lost updates”?
What is the difference between dropping a database and taking a database offline?
How check triggers in sql server?
What is the use of toad or sqldbx.?
What are indexes in sql?
Can you type more than one query in the query editor screen at the same time?
What is sql injection and why is it a problem? : sql server security
What is sql service broker?
What is the use of “join” in sql server?
How do use Having,Group by,Group function in SQL?
