Create Materialized View Command - Exercise
Understanding the syntax of creating a materialized view
Syntax of materialized views
Objective
Match 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.
EXPLAIN PLAN
TKPROF
V$SESSION_LONGOPS
Oracle Enterprise Manager
Works off of statistics gathered|||with the Trace utility
Multifaceted tool for gathering information|||about the operations of your Oracle8i database
Used to provide a step-by-step|||exposition of the execution plan
Real-time information about|||operations such as backup and recovery