Which of the following SQL statements correctly defines a composite primary key on columns customer_id and order_id?

easy📝 Syntax Q3 of 15

SQL - Table Constraints

Which of the following SQL statements correctly defines a composite primary key on columns customer_id and order_id?

APRIMARY KEY customer_id, order_id

BPRIMARY KEY (customer_id, order_id)

CPRIMARY KEY customer_id & order_id

DPRIMARY KEY customer_id + order_id

Step-by-Step Solution

Solution:

Step 1: Review syntax for composite keys
Composite primary keys require parentheses around the column list.
Step 2: Analyze options
Only PRIMARY KEY (customer_id, order_id) uses correct syntax: PRIMARY KEY (customer_id, order_id).
Final Answer:
PRIMARY KEY (customer_id, order_id) -> Option B
Quick Check:
Composite keys need parentheses [OK]

Quick Trick: Composite keys require parentheses around columns [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes