Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 77593 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
How do I completely remove sql server instance?
Explain error and transaction handling in sql server?
What number aggregate functions are accessible there in sql?
Explain about the command-line tool SQLCMD?
What are the advantages of using a stored procedure?
What is faster join or union?
Explain what is the difference between union and union all?
What are the types of user defined functions in sql server?
How do indexes help, types?
Difference between drill down and drill through report.
How each E-R model constructs can be mapped to the relational model?
Can we call future method from queueable?
How to delete duplicate records based on single column from a table?
Can we use where clause in union?
How do I manually uninstall an instance of sql server 2016?
