nerdexam
Oracle

1Z0-071 · Question #335

Which two statements are true about transactions in the Oracle Database server? (Choose two.)

The correct answer is C. Data Manipulation Language (DML) statements always start a new transaction. F. A session can always see uncommitted updates made by itself. See the full explanation below for the reasoning.

Question

Which two statements are true about transactions in the Oracle Database server? (Choose two.)

Options

  • AIf a session has an uncommitted transaction, then a DDL statement issues a COMMIT before
  • BAn uncommitted transaction commits automatically if the user exists SQL*Plus.
  • CData Manipulation Language (DML) statements always start a new transaction.
  • DA user can always see uncommitted updates made by the same user in a different session.
  • EA Data Definition Language (DDL) statement does a COMMIT automatically only for the data
  • FA session can always see uncommitted updates made by itself.

How the community answered

(21 responses)
  • A
    10% (2)
  • B
    10% (2)
  • C
    76% (16)
  • E
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice