Databases · Junior · Question 42 of 75

What is a view?

1A screenshot of a table
2A copy of a table that updates once a day
✓Correct answer: A saved query that you can select from like a table; data isn't stored separately

Explanation

Views hide complex joins and limit which columns users see. A materialized view, in contrast, stores the result and must be refreshed.

Further reading

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.