Automatic Index Management 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 Index Management in a database system?
  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. Which of the following scenarios is most likely to trigger the automatic creation of a new index?
  4. Why might an automatic index management system decide NOT to create a recommended index?
  5. In a high-concurrency environment, what is the risk of allowing an automatic tuning system to perform 'Online Index Creation' without restriction?

Answers and explanations come after you submit.