What is a limitation of a Materialized View?

The correct answer is D. A Materialized View cannot be defined with a JOIN. There are several limitations to using materialized views: A materialized view can query only a single table. Joins, including self-joins, are not supported.

Querying and Performance

Question

Options

AA Materialized View cannot support any aggregate functions
BA Materialized View can only reference up to two tables
CA Materialized View cannot be joined with other tables
DA Materialized View cannot be defined with a JOIN

How the community answered

(50 responses)

A
8% (4)
B
4% (2)
C
4% (2)
D
84% (42)

Explanation

There are several limitations to using materialized views: A materialized view can query only a single table. Joins, including self-joins, are not supported.

Topics

#materialized view#JOIN limitation#view restrictions

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice