A materialized view is/are:
A) a virtual table created dynamically on request by a user.
B) an in-line query.
C) copies or replica of data based on queries.
D) always an exact copy of the source table.

Question

Quizplus · Accepted Answer

A materialized view is a database object that contains the results of a query. It is a physical copy or replica of data that is stored and can be refreshed periodically. Unlike a virtual table or in-line query, it stores the data physically. It is not always an exact copy of the source table, as it can be based on complex queries that aggregate or transform the data.

A Materialized View Is/are