Multiple choice technology databases

When an executable SQL statement executes, a transaction begins. Which of the following events can NOT cause a transaction to end?

  1. The user disconnects from Oracle

  2. A COMMIT or a ROLLBACK statement is used in conjunction with a SAVEPOINT clause

  3. A user process is terminated abnormally

  4. A DDL statement such as DROP, GRANT, RENAME
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle, a transaction ends with a COMMIT, ROLLBACK, DDL statement, or disconnection. Using a SAVEPOINT with ROLLBACK only reverts to a specific point within the transaction; it does not terminate the transaction itself.

Keep practicing — related questions