Easy learning with example program codes

what are the transaction properties in sql?


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

Please follow and like us:
Posted in SQL   

Copyright © 2020 CodesJava Protection Status