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

Question

Quizplus · Accepted Answer

A materialized view, also known as a snapshot, is a dynamic table that contains not only the SQL query command to generate the rows but also stores the actual rows. It provides a way to cache and precompute expensive queries, which can significantly improve query performance. The data in the materialized view is updated periodically or when explicitly refreshed to keep it synchronized with the underlying data. OLAP, star schema, and data cube are not relevant to the definition.

A(n)____ Is a Dynamic Table That Not Only Contains the SQL