Which of the following is the correct syntax to define a composite primary key on columns order_id and product_id in SQL?

easy📝 Syntax Q12 of 15

SQL - Table Constraints

Which of the following is the correct syntax to define a composite primary key on columns order_id and product_id in SQL?

APRIMARY KEY (order_id, product_id)

BPRIMARY KEY order_id, product_id

CPRIMARY KEY order_id & product_id

DPRIMARY KEY (order_id + product_id)

Step-by-Step Solution

Solution:

Step 1: Recall SQL syntax for composite keys
Composite keys are defined by listing columns inside parentheses separated by commas.
Step 2: Match correct syntax
PRIMARY KEY (order_id, product_id) uses parentheses and comma correctly: PRIMARY KEY (order_id, product_id).
Final Answer:
PRIMARY KEY (order_id, product_id) -> Option A
Quick Check:
Composite key syntax uses parentheses and commas [OK]

Quick Trick: Use parentheses and commas for composite keys [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