nerdexam
Oracle

1Z0-061 · Question #73

In which three situations does a transaction complete?

The correct answer is C. When a PL/SQL anonymous block 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

(29 responses)
  • A
    10% (3)
  • B
    21% (6)
  • C
    69% (20)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice