Notifications
Clear all
Topic starter
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
Suggested 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.
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.
Posted : 05/01/2023 8:21 pm