SQL Quiz: What is a materialized view?

Task :

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

Cached data that is updated in real time whenever data changes

A temporary view that is deleted after each user session

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 table that can be modified directly by editing the source data

A database object that stores query results

A view that stores only unique rows from the source tables

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

Login