A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
A) SQL view
B) materialized view
C) star schema
D) data cube

Question

Quizplus · Accepted Answer

A materialized view is a physical copy of a query result set that is stored and updated periodically. It contains the actual rows and is useful when there are complex queries that take a long time to execute. Materialized views are faster to query than regular views because the results are already precomputed and stored.

A _____ Is a Dynamic Table That Not Only Contains