Query Optimizer  «Prev  Next»

DBMS Stats Package - Quiz

Select the best answer or answers for each question.
 
1. Which two features does the cost-based optimizer use that are not used by the rule-based optimizer?
Please select all the correct answers.
  A. Indexes
  B. Star schemas
  C. Partitions
  D. Hints

2. Why would you store an outline for a query?
Please select the best answer.
  A. To follow the optimizer default settings, as recommended
  B. To force the use of the rule-based optimizer
  C. To preserve a particular execution plan and the performance it delivers
  D. Because you know more about optimizing queries than the optimizer

3. Which features are a part of the procedures in the DBMS_STATS package that are not used by the ANALYZE command?
Please select all the correct answers.
  A. Parallel gathering of statistics, where possible
  B. External storage of statistics
  C. Storing execution plan in an outline
  D. Forcing the use of the rule-based optimizer