Which of the following is the correct syntax to create a materialized view named mv_customers selecting all columns from customers 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_customers selecting all columns from customers table?

ACREATE VIEW mv_customers AS SELECT * FROM customers;

BCREATE MATERIALIZED VIEW mv_customers AS SELECT * FROM customers;

CCREATE TABLE mv_customers AS SELECT * FROM customers;

DCREATE MATERIALIZED VIEW mv_customers SELECT * FROM customers;

Step-by-Step Solution

Solution:

Step 1: Recall correct syntax for materialized view creation
The syntax requires 'CREATE MATERIALIZED VIEW view_name AS SELECT ...'.
Step 2: Analyze options
CREATE MATERIALIZED VIEW mv_customers AS SELECT * FROM customers; matches correct syntax; A creates a regular view; C creates a table; D misses 'AS' keyword.
Final Answer:
CREATE MATERIALIZED VIEW mv_customers AS SELECT * FROM customers; -> Option B
Quick Check:
Create materialized view syntax = CREATE MATERIALIZED VIEW ... AS SELECT [OK]

Quick Trick: Use 'AS' keyword when creating materialized views [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