Oracle Database Administration I — Question 16

In which three situations does a new transaction always start? (Choose three.)

Answer options

• A. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
• B. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
• C. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
• D. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
• E. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
• F. when issuing a DML statement after a DML statement failed in the same session

Correct answer: A, D, F

Explanation

A new transaction begins when a SELECT FOR UPDATE statement is executed following a CREATE TABLE AS SELECT statement, as this requires a new context. The first DML statement after a COMMIT or ROLLBACK also initiates a new transaction, as does issuing a DML statement following a failed DML statement. The other options do not trigger a new transaction under the same conditions.