Oracle Database SQL — Question 249

An Oracle Database session has an uncommitted transaction in progress which updated 5000 rows in a table.
In which three situations does the transaction complete thereby committing the updates? (Choose three.)

Answer options

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

Correct answer: B, C, D

Explanation

The correct answers are B, C, and D because B involves a successful SHUTDOWN TRANSACTIONAL followed by a COMMIT, which commits the transaction. C indicates that logging out of the session will also commit uncommitted transactions. D signifies that executing a CREATE INDEX successfully in the same session will commit any uncommitted changes. Options A, E, and F do not result in committing the uncommitted transaction under the specified conditions.