Oracle Database SQL — Question 243

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

Answer options

• A. DML statements always start new transactions.
• B. DDL statements automatically commit only data dictionary updates caused by executing the DDL.
• 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 transaction.
• E. An uncommitted transaction is automatically committed when the user exits SQL*Plus.

Correct answer: D, E

Explanation

Option D is correct because a DDL statement will commit any uncommitted transactions before it executes. Option E is also correct as exiting SQL*Plus results in the automatic commit of any uncommitted transactions. The other options are incorrect; for instance, DML statements do not initiate new transactions automatically, and a session cannot see uncommitted changes from another session.