Question

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.

Answer 1

For starting the transaction some of the steps are issuing the BEGIN of the transaction command, by executing the transaction statement and then opening the transaction and keeping it open till the commit or roll back the statement.

Also to prevent the problems related to the transaction it is mostly defined by the atomic, consistent, isolated as well as durable data which contain the transaction and help in managing the data in the database.

Using the ACID property the transaction either has the effect or absolutely no effect.

The ACID property are meant for ensuring the accuracy, completeness, data integrity via the atomicity, consistency, isolation as well as durability.