Oracle Database 12c: Advanced Administration — Question 9

Which three statements are true about the database instance startup after an instance failure?

Answer options

• A. The RECO process recovers the uncommitted transactions at the next instance startup.
• B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.
• C. Uncommitted changes are rolled back to ensure transactional consistency.
• D. The SMON process coordinates the database recovery.
• E. Media recovery is required to complete the database recovery.
• F. Changes committed before the failure, which were not written to the data files, are re-applied.

Correct answer: A, C, D

Explanation

Option A is correct as the RECO process is responsible for recovering uncommitted transactions at the next startup. Option C is also correct because rolling back uncommitted changes is essential for ensuring consistency. Option D is valid since the SMON process plays a crucial role in coordinating the recovery, while the other options either discuss requirements not related to instance failure recovery or pertain to different recovery types.