Index Enhancements   «Prev  Next»

Computing Statistics - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. When can you compute statistics on an index?
Please select all the correct answers.
  A. When you perform maintenance operations
  B. When you create the index
  C. At any time with the ANALYZE command
  D. Only when the database is not operating

2. What two conditions typically cause a B*-tree index to become unbalanced?
Please select all the correct answers.
  A. It uses a value that increases over time.
  B. It uses a character value for the index.
  C. It uses multiple columns.
  D. Earlier values in the underlying table are deleted over time.

3. What is a good reason to use a descending index?
Please select the best answer.
  A. The index is in danger of becoming unbalanced over time.
  B. Common queries require the data in the associated table to return rows with a value in descending order.
  C. It is easier to compute statistics on a descending index.
  D. You must have an equal number of ascending and descending indexes on a table.