Automatic Plan Correction Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Automatic Tuning

What you'll be asked

  1. What is the primary purpose of Automatic Plan Correction in a database management system?
  2. When Automatic Plan Correction detects a regression, what action does it typically take?
  3. Which of the following is a prerequisite for Automatic Plan Correction to function effectively?
  4. How does the system determine that a new execution plan is performing worse than the previous one?
  5. In a scenario where Automatic Plan Correction has forced a plan, what happens if the database administrator manually updates the statistics for the underlying tables?

Answers and explanations come after you submit.