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)- A10% (2)
- B10% (2)
- C76% (16)
- E5% (1)
Community Discussion
No community discussion yet for this question.