Which two statements are true about the Oracle Database server during and immediately after SHUTDOWN IMMEDIATE?

Question

Options

• ANew connection requests made to the database instance are refused.
• BUncommitted transactions are rolled back automatically.
• CAll existing connections to the database instance remain connected until all transactions either roll
• DUncommitted transactions are allowed to continue to the next COMMIT.
• EAll existing transactions are aborted immediately.

• A
  92% (22)
• C
  4% (1)
• E
  4% (1)

Explanation

SHUTDOWN IMMEDIATE prevents new connections (A) and automatically rolls back any uncommitted transactions (B) before cleanly closing the database - no user intervention required.

Why the distractors are wrong:

• C is wrong because that describes SHUTDOWN TRANSACTIONAL, which waits for active transactions to complete before disconnecting sessions.
• D is wrong because IMMEDIATE does not let uncommitted work persist - it rolls it back; only SHUTDOWN NORMAL or SHUTDOWN TRANSACTIONAL allow transactions to finish naturally.
• E is wrong because "aborted immediately" without rollback describes SHUTDOWN ABORT, the most forceful mode, which skips the rollback phase entirely and requires instance recovery on the next startup.

Memory tip: Think of the shutdown modes as a spectrum of patience - NORMAL waits forever, TRANSACTIONAL waits for transactions, IMMEDIATE rolls back and closes cleanly, and ABORT just pulls the plug. "Immediate" means immediate cleanup (rollback + disconnect), not immediate termination without cleanup.

No community discussion yet for this question.