Which PostgreSQL command correctly creates a materialized view named mv_customers that selects all columns from the customers table?

easy📝 Syntax Q3 of 15

PostgreSQL - Views and Materialized Views

Which PostgreSQL command correctly creates a materialized view named mv_customers that selects all columns from the 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 TEMP VIEW mv_customers AS SELECT * FROM customers;

Step-by-Step Solution

Solution:

Step 1: Identify the command for materialized view creation
PostgreSQL uses CREATE MATERIALIZED VIEW to create materialized views.
Step 2: Verify the syntax
The syntax is CREATE MATERIALIZED VIEW view_name AS SELECT ....
Final Answer:
CREATE MATERIALIZED VIEW mv_customers AS SELECT * FROM customers; matches the correct syntax and purpose.
Quick Check:
Command uses CREATE MATERIALIZED VIEW and selects from customers [OK]

Quick Trick: Materialized views use CREATE MATERIALIZED VIEW [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