Which of the following commands correctly creates a hash partitioned table products partitioned by product_id in PostgreSQL?

easy📝 Syntax Q3 of 15

PostgreSQL - Table Partitioning

Which of the following commands correctly creates a hash partitioned table products partitioned by product_id in PostgreSQL?

ACREATE TABLE products (product_id INT, name TEXT) PARTITION BY HASH (product_id);

BCREATE TABLE products PARTITION BY HASH (product_id) (product_id INT, name TEXT);

CCREATE TABLE products (product_id INT, name TEXT) PARTITION BY RANGE (product_id);

DCREATE TABLE products (product_id INT, name TEXT) PARTITION BY LIST (product_id);

Step-by-Step Solution

Solution:

Step 1: Identify partitioning method
The question requires hash partitioning on product_id.
Step 2: Check syntax correctness
CREATE TABLE products (product_id INT, name TEXT) PARTITION BY HASH (product_id); uses correct syntax: PARTITION BY HASH (product_id) after table columns.
Step 3: Eliminate incorrect options
CREATE TABLE products PARTITION BY HASH (product_id) (product_id INT, name TEXT); has incorrect syntax order; Options C and D use different partitioning methods (RANGE, LIST).
Final Answer:
Option A -> Option A
Quick Check:
Correct syntax places PARTITION BY HASH after column definitions [OK]

Quick Trick: Use PARTITION BY HASH after columns [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