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