Home > DeveloperSection > Interviews > Explain ACID rule of thumb for transactions.

Posted on    December-31-2010 12:00 AM

 DB2 DB2 
 1 Answer(s)
  903  View(s)
Rate this:

Mahesh Rawat
Mahesh Rawat

Total Post:138

Posted on    December-31-2010 1:00 AM

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 hasn’t), 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).

Don't want to miss updates? Please click the below button!

Follow MindStick