Multiple choice technology databases

Which of the following advisors determines if the estimated instance recovery duration is within the expected service-level agreements?

  1. Undo Management Advisor

  2. SQL Access Advisor

  3. SQL Tuning Advisor

  4. MTTR Advisor
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The MTTR (Mean Time To Recover) Advisor evaluates if the estimated instance recovery duration meets service-level agreement requirements. It analyzes Redo log file sizing and configuration to optimize recovery time. Undo Management Advisor focuses on undo tablespace management, while SQL Access and Tuning Advisors deal with SQL optimization - not recovery time estimation.

Keep practicing — related questions