Which of the following is the correct syntax to refresh a materialized view named sales_summary in PostgreSQL?

easy📝 Syntax Q12 of 15

PostgreSQL - Views and Materialized Views

Which of the following is the correct syntax to refresh a materialized view named sales_summary in PostgreSQL?

AREFRESH MATERIALIZED VIEW sales_summary;

BUPDATE MATERIALIZED VIEW sales_summary;

CREFRESH VIEW sales_summary;

DALTER MATERIALIZED VIEW sales_summary REFRESH;

Step-by-Step Solution

Solution:

Step 1: Recall the correct command
The correct command to update a materialized view is REFRESH MATERIALIZED VIEW view_name;.
Step 2: Check each option
REFRESH MATERIALIZED VIEW sales_summary; matches the correct syntax. UPDATE MATERIALIZED VIEW sales_summary;, REFRESH VIEW sales_summary;, and ALTER MATERIALIZED VIEW sales_summary REFRESH; use invalid commands or keywords.
Final Answer:
REFRESH MATERIALIZED VIEW sales_summary; -> Option A
Quick Check:
Correct syntax uses REFRESH MATERIALIZED VIEW [OK]

Quick Trick: Use REFRESH MATERIALIZED VIEW followed by view name [OK]

Common Mistakes:

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free