In which three situations does a new transaction always start? (Choose three.)
Posted: Sun Jun 11, 2023 3:55 pm
In which three situations does a new transaction always start? (Choose three.)
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
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