Oracle Database 12c: Installation and Administration — Question 227

Which statement is true regarding the startup of a database instance?

Answer options

• A. The instance does not start up normally and requires manual media recovery after a shutdown using the abort option.
• B. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.
• C. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the immediate option or the abort option.
• D. Media recovery is required when the database is shut down by using either the immediate option or the abort option.
• E. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.

Correct answer: E

Explanation

The correct answer is E because when a database instance is shut down using SHUTDOWN IMMEDIATE, it ensures that all active transactions are completed and no recovery is needed upon startup. Options A, B, C, and D are incorrect because they suggest scenarios where recovery is required or imply that there is no difference in shutdown methods, which is not true in the context of immediate shutdowns.