Transaction Concepts In Database Explain With Examples

Transaction Concepts In Database Explain With Examples, What Is Transaction Control Explain With Examples, Describe Transaction Control

   Transaction is a collection of operations that form a single logical unit of work, which
    is either completely executed or not executed at all.

    A transaction is a unit of program execution that accesses and  possibly updates
     various data items.

A transaction is initiated by a user program written in a high level data manipulation language, where it enclosed by statements of the form ‘begin transaction’ and ‘end transaction’.

Examples:

Consider the following fund transfer transaction
Begin transaction
Transfer 100 from Account X to Account Y
Commit

Tweet