prev next

Course navigation

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. EXPLAIN PLAN
  2. TKPROF
  3. V$SESSION_LONGOPS
  4. Oracle Enterprise Manager
  1. Works off of statistics gathered|||with the Trace utility
  2. Multifaceted tool for gathering information|||about the operations of your Oracle8i database
  3. Used to provide a step-by-step|||exposition of the execution plan
  4. Real-time information about|||operations such as backup and recovery