The principle objective of a transaction is to facilitate data completeness when a sequence of events happens. Although it is not necessary that a “sequence of events” has to take place. A single event can also be considered as a transaction. A single event could be any data manipulation events like INSERTING, UPDATING or DELETING a row or set of rows.

Transaction is a logical unit of work. When we say a logical unit, it means the unit of work has a logic involved in it and this unit of work has to be performed in its completeness or not at all. A transaction cannot be completed partially.

For example, let’s say in an organization there is a change in the employee’s salary. This revised salary has to be applied to all the employees or none of the employees. Similarly when a bank pays interest on Savings Account, it has to pay interest on all the Savings Account that is present in the books or NONE.

Our Random Articles

• Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
• How To Choose A Good Online Traffic School
• New Year Wishes 2010
• New Year Wishes
• How to use EXTRACT function with date and time columns

More Links