A. A Materialized View cannot support any aggregate functions - Wrong - supports few aggregate functions but with some restrictions.
B. A Materialized View can only reference up to two tables - Wrong - can query only a single table.
C. A Materialized View cannot be joined with other tables - Wrong - We can.
D. A Materialized View cannot be defined with a JOIN - Correct - Joins, including self-joins, are not supported.
Answer is B. Query results contain a small number of rows and/or columns relative to the base table (the table on which the view is defined).The base table, only one table.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
tejarun
Highly Voted 1 year, 11 months agoJosa2
Highly Voted 1 year, 8 months agoThaiya
1 year, 2 months agoThaiya
1 year, 2 months agohotflake
Most Recent 3 months, 2 weeks agoMallikharjuna452
4 months ago_yyukta
8 months, 3 weeks agoDavidMiller
11 months agolol632
11 months, 3 weeks ago[Removed]
1 year, 1 month agoThaiya
1 year, 2 months agoThaiya
1 year, 2 months agojackjack123
1 year, 3 months agoSexyPotato
1 year, 8 months agoAS314
1 year, 10 months agodb1290
1 year, 11 months ago