Which two are true about transactions in the Oracle Database? (Choose two.)
Which two are true about transactions in the Oracle Database? (Choose two.)
A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction because DDL statements in Oracle implicitly commit any pending transactions before they are executed. An uncommitted transaction is automatically committed when the user exits SQL*Plus because exiting SQL*Plus implicitly commits any pending transactions, ensuring that no data is lost.
A. DML statements always start new transactions. (X). Not always B. DDL statements automatically commit only data dictionary updates caused by executing the DDL. (X) Not "only" data dictionary C. A session can see uncommitted updates made by the same user in a different session. (X) in the same 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.
https://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve040.htm#BABEGEGC
True hehe
should be DE SET AUTOCOMMIT does not alter the commit behavior when SQL*Plus exits. Any uncommitted data is committed by default.
The answer is BE
bd is correct
The answer is DE