Performance Tuning   «Prev  Next»

Create Materialized View Command - Exercise

Understanding the syntax of creating a materialized view
Syntax of materialized views
ObjectiveMatch a clauses in a CREATE MATERIALIZED VIEW statement with its purpose.

Exercise Scoring

Match items in the left column with the items in the right column. When you have completed the exercise, click the Submit button to receive full credit.

Instructions

In the left column below are four terms and their corresponding definitions in the right column. When you think you have all of the terms and their definitions matched correctly, click the Submit button and you will see a result set on the following page. When you have completed the exercise, click the Submit button to see the correct answers.

  1. COMPLETE/FAST/FORCE/NEVER
  2. ENABLE/DISABLE QUERY REWRITE
  3. BUILD IMMEDIATE/DEFERRED
  4. ON COMMIT/DEMAND
  5. storage_clause
  1. Indicates when the actual data for the view is assembled.
  2. Indicates how the data for the view will be stored.
  3. Indicates when the data for a materialized view is updated.
  4. Indicates whether the cost-based optimizer will use a materialized view.
  5. Indicates how the data for a materialized view will be updated.