Q152 Which two are true about transactions in the Oracle Database?
- A) A session can see uncommitted updates made by the same user in a different session.
- B) A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction.
- C) An uncommitted transaction is automatically committed when the user exits SQL*Plus.
- D) DDL statements automatically commit only data dictionary updates caused by executing the DDL.
- E) DML statements always start new transactions.
Answer: B, C
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/COMMIT.html
Oracle Database issues an implicit COMMIT under the following circumstances:
• Before any syntactically valid data definition language (DDL) statement, even if the statement results in an error
• After any data definition language (DDL) statement that completes without an error
A normal exit from most Oracle utilities and tools causes the current transaction to be committed.