Multiple choice technology databases

Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined? (Choose three)

  1. TARGET_REDO_BLKS

  2. FAST_START_IO_TARGET

  3. LOG_CHECKPOINT_TIMEOUT

  4. RECOVERY_ESTIMATED_IOS

  5. LOG_FILE_SIZE_REDO_BLKS

  6. LOG_CHECKPOINT_INTERVAL
Reveal answer Fill a bubble to check yourself
B,C,F Correct answer
Explanation

FAST_START_MTTR_TARGET is a simplified parameter that automatically manages several recovery-related initialization parameters. When set, Oracle automatically controls FAST_START_IO_TARGET (I/O targets for recovery), LOG_CHECKPOINT_TIMEOUT (time-based checkpoint frequency), and LOG_CHECKPOINT_INTERVAL (redo-based checkpoint frequency). These manual parameters become redundant and should not be set.

Keep practicing — related questions