Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78073 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 data source view or dsv? : sql server analysis services, ssas
Is it true, that there is no difference between a rule and a check constraint?
Explain the concept of view and Types of views in SQL server?
Can you leave a union at any time?
Write a query to find 5th highest amount paid from the customer table.
What are translations and its use? : sql server analysis services, ssas
Is it possible to create trigger on views?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is log cache in sql server?
Name 3 ways to get an accurate count of the number of records in a table?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
When I delete any data from a table, does the sql server reduce the size of that table?
What does it mean to manipulate data?
Write a query for primary key constraint with identity key word?
How to get the query of a table in sql server?
