Explain ACID rule of thumb for transactions.

Transaction must be Atomic (it is one unit of work and does not dependent on previous and following transactions), Consistent (data is either committed or roll back, no “in-between” case where something has been updated and something hasnot), Isolated (no transaction sees the intermediate results of the current transaction), Durable (the values persist if the data had been committed even if the system crashes right after).
  • Interview Candidate
  • 1
  • 9103

Showing Answers 1 - 1 of 1 Answers

sahu

  • Jan 9th, 2006
 

Ans:

ACID:

Expanding

A:Atomic

Transaction must be Atomic (it is one unit of work and does not dependent on previous and following transactions)

C:Consistent

Consistent (data is either committed or roll back, no ?in-between? case where something has been updated and something hasnot)

I:Isolated

Isolated (no transaction sees the intermediate results of the current transaction)

D:Durable

Durable (the values persist if the data had been committed even if the system crashes right after).

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions