Bird
0
0

Which of the following statements about refreshing materialized views is TRUE?

easy📝 Conceptual Q2 of 15
PostgreSQL - Views and Materialized Views

Which of the following statements about refreshing materialized views is TRUE?

ARefreshing a materialized view can be done manually using the <code>REFRESH MATERIALIZED VIEW</code> command
BRefreshing a materialized view always happens automatically after base table updates
CMaterialized views do not need refreshing because they always show live data
DRefreshing a materialized view locks the base tables for the duration of the refresh
Step-by-Step Solution
Solution:

  1. Step 1: Understand automatic vs manual refresh

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

  2. Step 2: Identify correct statement

    Only manual refresh via the command is true; others are false.

  3. Final Answer:

    Refreshing a materialized view can be done manually using the REFRESH MATERIALIZED VIEW command -> Option A

  4. Quick Check:

    Manual refresh = True [OK]
Quick Trick: Materialized views refresh manually, not automatically [OK]
Common Mistakes:
  • Assuming automatic refresh after every base table change
  • Believing base tables are locked during refresh
  • Thinking materialized views always show live data

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes
Common Table Expressions - Recursive CTE for hierarchical data - Quiz 7medium Common Table Expressions - Multiple CTEs in one query - Quiz 4medium Common Table Expressions - WITH clause syntax - Quiz 10hard Full-Text Search - Ranking with ts_rank - Quiz 2easy JSON and JSONB - JSONB modification functions - Quiz 8hard Joins in PostgreSQL - NATURAL join and its risks - Quiz 10hard Subqueries in PostgreSQL - Correlated subqueries execution model - Quiz 11easy Window Functions in PostgreSQL - LAG and LEAD for row comparison - Quiz 15hard Window Functions in PostgreSQL - SUM, AVG, COUNT as window functions - Quiz 14medium Window Functions in PostgreSQL - Practical window function patterns - Quiz 1easy