nerdexam
Oracle

1Z0-071 · Question #21

Which statement is true about transactions?

The correct answer is B. Each Data Definition Language (DDL) statement executed forms a single transaction. https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

Exadata Administration

Question

Which statement is true about transactions?

Options

  • AA set of Data Manipulation Language (DML) statements executed in a sequence ending with a
  • BEach Data Definition Language (DDL) statement executed forms a single transaction.
  • CA set of DDL statements executed in a sequence ending with a COMMIT forms a single
  • DA combination of DDL and DML statements executed in a sequence ending with a COMMIT

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    76% (22)
  • C
    7% (2)
  • D
    14% (4)

Explanation

https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

Topics

#transactions#DDL auto-commit#DML#COMMIT behavior

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice