Which three situations does a new transaction always start?

In which three situations does a new transaction always start?
A. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
B. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully 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 DML statement after a DML statement failed in the same session
F. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

Download Printable PDF. VALID exam to help you PASS.

3 thoughts on “Which three situations does a new transaction always start?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.