Which of the following is the correct syntax to create a materialized view named sales_summary from a table sales?

easy📝 Syntax Q12 of 15

PostgreSQL - Views and Materialized Views

Which of the following is the correct syntax to create a materialized view named sales_summary from a table sales?

ACREATE MATERIALIZED VIEW sales_summary AS SELECT * FROM sales;

BCREATE VIEW MATERIALIZED sales_summary AS SELECT * FROM sales;

CCREATE MATERIALIZED VIEW sales_summary SELECT * FROM sales;

DCREATE MATERIALIZED VIEW sales_summary FROM sales;

Step-by-Step Solution

Solution:

Step 1: Recall the correct syntax for creating materialized views
The correct syntax is: CREATE MATERIALIZED VIEW view_name AS SELECT ...
Step 2: Check each option against this syntax
CREATE MATERIALIZED VIEW sales_summary AS SELECT * FROM sales; matches exactly. CREATE VIEW MATERIALIZED sales_summary AS SELECT * FROM sales; swaps keywords incorrectly. CREATE MATERIALIZED VIEW sales_summary SELECT * FROM sales; misses the AS keyword. CREATE MATERIALIZED VIEW sales_summary FROM sales; uses FROM instead of AS and SELECT.
Final Answer:
CREATE MATERIALIZED VIEW sales_summary AS SELECT * FROM sales; -> Option A
Quick Check:
Syntax = CREATE MATERIALIZED VIEW ... AS SELECT ... [OK]

Quick Trick: Use 'AS SELECT' after materialized 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