SQL Interview Questions #162: What is a materialized view?

SQL code copied to buffer

Group tasks by:

complexity

category

database

Task 162:

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

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

A temporary view that is deleted after each user session

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

Cached data that is updated in real time whenever data changes

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

A view that stores only unique rows from the source tables

A database object that stores query results

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

SQL in 10 Minutes a Day by Ben Forta

SQL in 10 Minutes a Day by Ben Forta

Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.