1Z0-182 practice question 5 of 15

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

Full set: 94 questions

Answer options

A: Instance recovery occurs automatically during the shutdown.

B: Uncommitted transactions are allowed to continue to the next ROLLBACK.

C: New connection requests made to the database instance are refused. Correct answer

D: Sessions remain connected even if they are not running a transaction. Correct answer

E: Uncommitted transactions are allowed to continue to the next COMMIT. Correct answer

Correct Answer:

C. New connection requests made to the database instance are refused.; D. Sessions remain connected even if they are not running a transaction.; E. Uncommitted transactions are allowed to continue to the next COMMIT.

Explanation

After SHUTDOWN TRANSACTIONAL is issued, the instance refuses new connection attempts (C). Existing sessions remain connected if not currently in a transaction, although they cannot begin new transactions (D). Active uncommitted transactions are allowed to finish naturally—either to a COMMIT (E) or, if users choose, a ROLLBACK; shutdown proceeds only after completion.

Why Incorrect

A. No instance recovery occurs; the shutdown is clean.
B. Oracle waits for completion, not specifically for the next explicit ROLLBACK; users may commit instead.

References

1. Oracle Database Administrator’s Guide 23c, “Shutting Down and Starting Up – Shutdown Modes”, Table 10-3 (“TRANSACTIONAL”)

2. Oracle SQLPlus User’s Guide and Reference 23c, “SHUTDOWN Command”, sub-topic “TRANSACTIONAL”

Keep practicing

Take the free 1Z0-182 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test