为自己加油

An Oracle database session has an uncommitted transaction in progress which updated
5000 rows in atable
In which three situations does the transaction complete thereby committing the updates?

A.when a CREATE TABLE AS SELECT statement is issued in the same session but
Fails with asyntax error
B.when a CONMIT statement is issued by the same user from another session in the
Same database instance
C.when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user
Then issues a COMMIT
D.when a CREATE INDEX statement is executed successfully in the same session
E.when the session logs out successfully
F.when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the
User then issues a COMMIT