Which two are true about transactions in the Oracle Database?

B . True. DDL (Data Definition Language) statements in Oracle Database are auto-commit statements.

This means that if a DDL statement is issued, any uncommitted transactions in the same session will

automatically be committed.

D . False. This is a common misconception. DML (Data Manipulation Language) statements do not

automatically start new transactions. In Oracle, a transaction begins when the first DML statement

(INSERT, UPDATE, DELETE, MERGE, SELECT FOR UPDATE) is encountered after a previous transaction

has been committed or rolled back.

A is incorrect because DDL statements automatically commit the entire transaction, not just the data

dictionary updates. C is incorrect because an uncommitted transaction is not automatically

committed when a user exits SQL*Plus; instead, it is rolled back. E is incorrect because a session

cannot see uncommitted updates made by other sessions.

Reference: Oracle Database SQL Language Reference 12c, Transaction Control - COMMIT