Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 77350 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 does null mean?
what's new in sql server 2016?
What are Spatial data types in SQL Server 2008
What is the full form of dql?
Explain user defined functions?
What is forward - only cursors / read only cursor?
Can a table be created inside a trigger?
How to disable a login name in ms sql server?
System requirements for sql server 2005 express edition?
Explain what is the function of sql server agent windows service?
What happens if null values are involved in datetime operations?
Define a cross join?
Why use view instead of a table?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is a domain constraint give an example?
