Which of the following scenarios ends an Oracle transaction?

Options
- COMMIT or ROLLBACK is issued
- User disconnects from Oracle
- User process terminates abnormally
- All of the above

CORRECT ANSWER : All of the above

Discussion Board
Oracle Transaction

A transaction ends when any of the following actions occurs:

1. A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause.
- In a commit, a user explicitly or implicitly requested that the changes in the transaction be made permanent.
- Changes made by the transaction are permanent and visible to other users only after a transaction commits.

2. A user runs a DDL command such as CREATE, DROP, RENAME, or ALTER.
- The database issues an implicit COMMIT statement before and after every DDL statement.
- If the current transaction contains DML statements, then Oracle Database first commits the transaction and then runs and commits the DDL statement as a new, single-statement transaction.

3. A user exits normally from most Oracle Database utilities and tools, causing the current transaction to be implicitly committed. The commit behavior when a user disconnects its application-dependent and configurable.

4. A client process terminates abnormally, causing the transaction to be implicitly rolled back using metadata stored in the transaction table and the undo segment.

Prajakta Pandit 02-17-2017 04:27 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲