Oracle Database Administration I — Question 150

Which three statements are true about the Oracle Database server during and immediately after
SHUTDOWN TRANSACTIONAL? (Choose three.)

Answer options

• A. Sessions remain connected even if they are not running a transaction.
• B. Uncommitted transactions are allowed to continue to the next COMMIT.
• C. Uncommitted transactions are allowed to continue to the next ROLLBACK.
• D. Instance recovery occurs automatically during the shutdown.
• E. Instance recovery occurs at the next restart.
• F. New connection requests made to the database instance are refused.

Correct answer: A, B, F

Explanation

The correct answers A, B, and F are true because during a SHUTDOWN TRANSACTIONAL, sessions stay connected even when not running transactions, uncommitted transactions can still be committed, and new connection requests are denied. Options C, D, and E are incorrect as uncommitted transactions cannot proceed to ROLLBACK during this state, instance recovery does not occur until the next restart, and recovery does not happen automatically during shutdown.