Transaction Control

Transaction control involves coordinating multiple concurrent accesses to the same data. When one session is changing data that another session is accessing, Oracle uses transactions to control which users have visibility to changing data and when they can see the changed data. Transactions represent an atomic unit of work. All changes to data in a transaction are applied together or rolled back (undone) together. Transactions provide data consistency in the event of a user-process failure or system failure.

In your organization, the company's CIO is concerned about incidents in which statements committed changes without finishing up the whole series of statements. These incidents caused the data to be inconsistent, with errors in the later statements that did not get changed.

Write a memo in which you address how the use of transactions can help resolve this issue. Provide example database setup. Explain the importance of an atomic transaction.