Explore BrainMass

Explore BrainMass

    key concepts that are involved in transaction processing

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Explain the key concepts that are involved in transaction processing. Define the concepts and provide an explanation of the commands that are involved in the transaction. Also, explain the advantages of using transaction processing in your code.

    © BrainMass Inc. brainmass.com December 24, 2021, 5:02 pm ad1c9bdddf

    Solution Preview

    A transaction is a series of logically related SQL statements that Oracle treats as a unit so that all changes brought about by the statements are made permanent or undone at the same time.

    All the data manipulation statements executed since the last data definition, COMMIT or ROLLBACK statement was executed make up the current transaction.

    Some of the basic commands are:
    COMMIT WORK makes permanent any changes made during the current transaction.
    ROLLBACK WORK ends the current transaction and undoes any changes made since the transaction ...

    Solution Summary

    The solution emphasizes key concepts that are involved in transaction processing.