What is a limitation of a Materialized View?

What is a limitation of a Materialized View?
A . A Materialized View cannot support any aggregate functions
B. A Materialized View can only reference up to two tables
C. A Materialized View cannot be joined with other tables
D. A Materialized View cannot be defined with a JOIN

Answer: D

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.

Latest COF-C02 Dumps Valid Version with 254 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments