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

View Answer

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.