What is a materialized view?

Question

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

Answer 1

A temporary view that is deleted after each user session

Answer 2

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

Answer 3

A view that stores only unique rows from the source tables

Answer 4

A database object that stores query results

Answer 5

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

Answer 6

Cached data that is updated in real time whenever data changes

Answer 7

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

Practice