CodesJava

Easy learning with example program codes

what are the transaction properties in sql?


Transaction

A transaction is a sequence of operation which works as an atomic unit. A transaction only completes if all the operations completed successfully. A transaction has the Atomicity, Consistency, Isolation and Durability properties (ACID).

[A]tomic: Everything succeeds or fails as a single unit.
[C]onsistent: When the operation is complete, every thing is left in a safe state.
[I]solated: No other operation can impact me operation.
[D]urable: When the operation is completed, changes are safe

Related topics

Posted in SQL   


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap