Oracle
1Z0-071 · Question #418
Which two are true about transactions in the Oracle Database? (Choose two.)
The correct answer is C. A session can see uncommitted updates made by the same user in a different session. D. A DDL statement issued by a session with an uncommitted transaction automatically commits that. See the full explanation below for the reasoning.
Question
Which two are true about transactions in the Oracle Database? (Choose two.)
Options
- ADML statements always start new transactions.
- BDDL statements automatically commit only data dictionary updates caused by executing the DDL.
- CA session can see uncommitted updates made by the same user in a different session.
- DA DDL statement issued by a session with an uncommitted transaction automatically commits that
- EAn uncommitted transaction is automatically committed when the user exits SQL*Plus.
How the community answered
(20 responses)- A5% (1)
- B10% (2)
- C85% (17)
Community Discussion
No community discussion yet for this question.