Oracle Exam 1Z0-082 Topic 2 Question 42 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 42
Topic #: 2

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

Awhen issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

Bwhen issuing a TRUNCATE statement after a SELECT statement was issued in the same session

Cwhen issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

Dwhen issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

Ewhen issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

Fwhen issuing a DML statement after a DML statement failed in the same session

Show Suggested Answer

Suggested Answer: A, D, E

by Veronika at May 06, 2022, 01:43 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!