Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 49 of 50

Marks: +1, -0

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

when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
when issuing the first Data Manipulation Language (DML) statement after a COMMIT or ROLLBACK statement was issued in the same session
when issuing a DML statement after a DML statement failed in the same session
when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session C

Go to Question:

Prev Question

Next Question