Which of the following is the correct syntax to create a materialized view named mv_sales that selects all columns from sales table?

easy📝 Syntax Q3 of 15

PostgreSQL - Views and Materialized Views

Which of the following is the correct syntax to create a materialized view named mv_sales that selects all columns from sales table?

ACREATE MATERIALIZED VIEW mv_sales SELECT * FROM sales;

BCREATE MATERIALIZED VIEW mv_sales AS SELECT * FROM sales;

CCREATE MATERIALIZED VIEW mv_sales FROM sales;

DCREATE VIEW MATERIALIZED mv_sales AS SELECT * FROM sales;

Step-by-Step Solution

Solution:

Step 1: Recall correct syntax structure
The correct syntax is: CREATE MATERIALIZED VIEW view_name AS SELECT ...
Step 2: Check each option
CREATE MATERIALIZED VIEW mv_sales AS SELECT * FROM sales; matches the correct syntax; others have wrong keyword order or missing AS.
Final Answer:
CREATE MATERIALIZED VIEW mv_sales AS SELECT * FROM sales; -> Option B
Quick Check:
Syntax for materialized view = CREATE MATERIALIZED VIEW ... AS SELECT [OK]

Quick Trick: Use AS before SELECT in materialized view creation [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