Bird
0
0

Which statement about refreshing a materialized view is true?

easy📝 Conceptual Q2 of 15
PostgreSQL - Views and Materialized Views
Which statement about refreshing a materialized view is true?
AIt automatically updates whenever the base tables change.
BIt cannot be refreshed once created.
CYou must manually refresh it to see updated data.
DIt refreshes only when the database restarts.
Step-by-Step Solution
Solution:

  1. Step 1: Recall how materialized views update

    Materialized views do not update automatically; they require manual refresh.

  2. Step 2: Eliminate incorrect options

    Automatic updates or refresh on restart are not supported; refresh is possible anytime manually.

  3. Final Answer:

    You must manually refresh it to see updated data. -> Option C

  4. Quick Check:

    Materialized View Refresh = Manual [OK]
Quick Trick: Materialized views need manual refresh to update data [OK]
Common Mistakes:
  • Assuming automatic refresh on data change
  • Believing refresh happens on database restart
  • Thinking refresh is impossible

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes
Common Table Expressions - Why CTEs matter in PostgreSQL - Quiz 5medium Full-Text Search - Why full-text search matters - Quiz 7medium Full-Text Search - Highlighting with ts_headline - Quiz 9hard JSON and JSONB - Arrow operators (-> and ->>) - Quiz 7medium JSON and JSONB - Arrow operators (-> and ->>) - Quiz 5medium JSON and JSONB - JSON vs JSONB differences - Quiz 6medium Joins in PostgreSQL - LEFT JOIN and RIGHT JOIN - Quiz 11easy Joins in PostgreSQL - NATURAL join and its risks - Quiz 8hard Set Operations and Advanced Queries - UNION and UNION ALL - Quiz 9hard Window Functions in PostgreSQL - Practical window function patterns - Quiz 3easy