Oracle Linux 8 System Administration — Question 5

Which statement is applicable after the Oracle Database server has been shut down using the SHUTDOWN TRANSACTIONAL command?

Answer options

• A. Instance recovery occurs automatically during the shutdown.
• B. Uncommitted transactions are allowed to continue to the next COMMIT or ROLLBACK.
• C. Instance recovery occurs at the next restart.

Correct answer: C

Explanation

The correct answer is C because when the SHUTDOWN TRANSACTIONAL command is used, the database allows existing transactions to finish but ensures that any recovery process will be initiated when the database is restarted. Option A is incorrect as instance recovery does not occur during shutdown, and option B is also wrong because uncommitted transactions are not allowed to continue; they are rolled back during the shutdown process.