nerdexam
Oracle

1Z0-071 · Question #86

In which three situations does a transaction complete?

The correct answer is B. When a ROLLBACK command is executed D. When a data definition language (DDL) statement is executed E. When a TRUNCATE statement is executed after the pending transaction. See the full explanation below for the reasoning.

Question

In which three situations does a transaction complete?

Options

  • AWhen a DELETE statement is executed
  • BWhen a ROLLBACK command is executed
  • CWhen a PL/SQL anonymous block is executed
  • DWhen a data definition language (DDL) statement is executed
  • EWhen a TRUNCATE statement is executed after the pending transaction

How the community answered

(48 responses)
  • A
    6% (3)
  • B
    75% (36)
  • C
    19% (9)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice