Transaction
- A unit of work done against the DB in a logical sequence.
- It is a logical unit of work that
contains one or more SQL statements
- All these statements in a transaction either gets
Completed successfully
(all the changes made to the database are permanent)- Or if at any point any
failure happens
it gets rollbacked (all the changes being done are undone.)
- Sequence is very important in transaction.