Oracle Database 12c: Installation and Administration — Question 117

Which four are true about the SHUTDOWN TRANSACTIONAL command and its effects in a single instance Oracle database environment with a single active transaction? (Choose four.)

Answer options

• A. The Oracle server waits for all sessions to disconnect before completing the shutdown.
• B. An instance shutdown will occur if the transaction issues a COMMIT.
• C. Sessions are unable to begin new transactions.
• D. All sessions are terminated when the transaction ends.
• E. An instance shutdown will occur if the transaction issues a ROLLBACK.
• F. All the active transactions are rolled back and all user sessions are terminated.
• G. The next startup requires instance recovery, which occurs automatically.

Correct answer: C, E, F, G

Explanation

Option C is correct because sessions cannot start new transactions while a shutdown is in progress. Option E is accurate as the instance will shut down if a ROLLBACK is issued. Option F is correct since all active transactions are indeed rolled back, and user sessions are terminated. Option G is true because instance recovery is required after a shutdown, and this process occurs without manual intervention.