Performance Tuning   «Prev  Next»

Materialized Views - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. What type of index is recommended for a materialized view containing only joins, if you want to use the fast refresh method?
Please select the best answer.
  A. A bitmapped index.
  B. An index on each of the columns used in the joins.
  C. An index on the ROWIDs of each of the tables used in the join.
  D. No specific indexes are recommended.

2. Which of the following conditions must exist for a materialized view to be used in a query rewrite?
Please select all the correct answers.
  A. The materialized view must be specified in the query.
  B. Query rewrite must be enabled for the session.
  C. The query has to match the materialized view exactly.
  D. The materialized view must have query rewrite enabled.

3. What is the difference between the RECOMMEND_MV procedure and the RECOMMEND_MV_W procedure?
Please select the best answer.
  A. The RECOMMEND_MV procedure looks at the workload on the database, whereas the RECOMMEND_MV_W procedure does not.
  B. The RECOMMEND_MV_W procedure looks at the workload on the database, whereas the RECOMMEND_MV_W procedure does not.
  C. The RECOMMEND_MV procedure uses statistics to determine recommendations, whereas the RECOMMEND_MV_W procedure does not.
  D. The RECOMMEND_MV_W procedure uses statistics to determine recommendations, whereas the RECOMMEND_MV procedure does not.