Which three situations does the transactions complete thereby committing the updates?

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table.
In which three situations does the transactions complete thereby committing the updates? (Choose three.)
A. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
B. when a CREATE INDEX statement is executed successfully in the same session
C. when a COMMIT statement is issued by the same user from another session in the same database instance
D. when the session logs out successfully
E. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT
F. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

Download Printable PDF. VALID exam to help you PASS.