SQL Quiz: What is a materialized view?

Task 164:

Select the correct definition of Materialized Views from the options below:

A temporary view that is deleted after each user session

A table that can be modified directly by editing the source data

A dynamically updating table that automatically adds new rows whenever data changes

A view with a limited number of rows that is always stored in RAM

A database object that stores query results

A view that stores only unique rows from the source tables

Cached data that is updated in real time whenever data changes

Mark all correct answers and click the "Check!" button

Login