Oracle Database 11g: Administration I — Question 6

Which two are true about FAST_START_MTTR_TARGET? (Choose two.)

Answer options

• A. It is overridden by LOG_CHECKPOINT_INTERVAL
• B. If it is set to 0, the MTTR Advisor is disabled
• C. A higher value increases the I/O overhead
• D. It is applicable only when the database is in ARCHIVELOG mode
• E. A lower value increases the time taken to perform instance recovery

Correct answer: A, C

Explanation

Answer A is correct because LOG_CHECKPOINT_INTERVAL takes precedence over FAST_START_MTTR_TARGET. Answer C is also correct as a higher value for FAST_START_MTTR_TARGET does indeed increase I/O overhead. Options B, D, and E are incorrect as they misrepresent the effects or conditions related to FAST_START_MTTR_TARGET.