Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78019 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
Explain forward - only cursors?
What is the contrast amongst drop and truncate?
How do you make a trace?
What are the operating modes in which database mirroring runs?
How does clustered and non clustered index work?
What is normalization and what are the advantages of it?
Can we insert data into view sql server?
Give an example of SQL injection attack ?
How to transfer an existing table from one schema to another schema in ms sql server?
How to enter unicode character string literals in ms sql server?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What are scalar functions in sql?
What is a db view?
What is the query and subquery?
Which table keeps information about stored procedures?
