Q41 An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table

Q41 An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table. Which three situations does the transaction complete thereby committing the updates?

• (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