[Solved] Given the following commands:CREATE TABLE products (id INT, price INT);... CREATE MATERIALIZED VIEW cheap_products AS SELECT * FROM products WHERE price What will be the output of the SELECT query? | PostgreSQL

PostgreSQL - Views and Materialized Views

Given the following commands:

CREATE TABLE products (id INT, price INT);
INSERT INTO products VALUES (1, 100), (2, 200);
CREATE MATERIALIZED VIEW cheap_products AS SELECT * FROM products WHERE price < 150;
SELECT * FROM cheap_products;

What will be the output of the SELECT query?

ARows with id=1 and price=100

BRows with id=2 and price=200

CNo rows returned

DSyntax error

Step-by-Step Solution

Solution:

Step 1: Understand the data and materialized view filter
The table has two rows: (1,100) and (2,200). The materialized view selects rows where price < 150, so only (1,100) qualifies.
Step 2: Query the materialized view
Since the materialized view stores the filtered rows, selecting from it returns the row with id=1 and price=100.
Final Answer:
Rows with id=1 and price=100 -> Option A
Quick Check:
Filter price < 150 = row with id=1 [OK]

Quick Trick: Materialized view stores filtered rows, returns matching data [OK]

Common Mistakes:

Expecting all rows instead of filtered ones
Confusing materialized view with normal view behavior
Assuming syntax error due to multiple commands

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Given the following commands:

Step 1: Understand the data and materialized view filter

Step 2: Query the materialized view

Final Answer:

Quick Check:

Want More Practice?