Automatic Index Management Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Automatic Tuning

Automatic Index Management Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    What is the primary purpose of Automatic Index Management in a database system?

  2. 2

    When the database engine identifies an 'unused index' during an automatic tuning cycle, what is the recommended best practice for the system to perform?

  3. 3

    Which of the following scenarios is most likely to trigger the automatic creation of a new index?

  4. 4

    Why might an automatic index management system decide NOT to create a recommended index?

  5. 5

    In a high-concurrency environment, what is the risk of allowing an automatic tuning system to perform 'Online Index Creation' without restriction?