nerdexam
Oracle

1Z0-082 · Question #80

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

The correct answer is A. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT D. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR F. when issuing a DML statement after a DML statement failed in the same session. See the full explanation below for the reasoning.

Manage Data Concurrency

Question

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

Options

  • Awhen issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT
  • Bwhen issuing a TRUNCATE statement after a SELECT statement was issued in the same
  • Cwhen issuing a CREATE TABLE statement after a SELECT statement was issued in the same
  • Dwhen issuing the first Data Manipulation Language (DML) statement after a COMMIT OR
  • Ewhen issuing a CREATE INDEX statement after a CREATE TABLE statement completed
  • Fwhen issuing a DML statement after a DML statement failed in the same session

How the community answered

(35 responses)
  • A
    71% (25)
  • B
    6% (2)
  • C
    14% (5)
  • E
    9% (3)

Topics

#transaction management#DML#DDL auto-commit#COMMIT

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice