You have a partitioned table by LIST on region. You want to add a new partition for region 'Asia'. Which command is correct?

hard📝 Application Q9 of 15

PostgreSQL - Table Partitioning

You have a partitioned table by LIST on region. You want to add a new partition for region 'Asia'. Which command is correct?

AALTER TABLE sales ADD PARTITION FOR VALUES IN ('Asia');

BCREATE TABLE sales_asia PARTITION OF sales FOR VALUES IN ('Asia');

CCREATE PARTITION sales_asia FOR VALUES IN ('Asia');

DALTER TABLE sales ADD PARTITION sales_asia VALUES ('Asia');

Step-by-Step Solution

Solution:

Step 1: Recall syntax to add partition
New partitions are created with CREATE TABLE ... PARTITION OF ... FOR VALUES IN (...).
Step 2: Match correct syntax
CREATE TABLE sales_asia PARTITION OF sales FOR VALUES IN ('Asia'); matches the correct syntax to add a partition for 'Asia'.
Final Answer:
CREATE TABLE sales_asia PARTITION OF sales FOR VALUES IN ('Asia'); -> Option B
Quick Check:
Adding partition uses CREATE TABLE PARTITION OF [OK]

Quick Trick: Add partitions with CREATE TABLE PARTITION OF [OK]

Common Mistakes:

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free