To create the primary key clause for the OrderLine table on the OrderNum and ItemNum fields,the correct statement is ____.
A) PRIMARY KEY (OrderLine, OrderNum, ItemNum)
B) KEY (OrderNum, ItemNum)
C) PRIMARY KEY (OrderNum, ItemNum)
D) PRIMARY (OrderNum, ItemNum)

Question

​To create the primary key clause for the OrderLine table on the OrderNum and ItemNum fields,the correct statement is ____.
A) ​PRIMARY KEY (OrderLine, OrderNum, ItemNum)
B) ​KEY (OrderNum, ItemNum)
C) ​PRIMARY KEY (OrderNum, ItemNum)
D) ​PRIMARY (OrderNum, ItemNum)

Quizplus · Accepted Answer

The correct syntax for creating a primary key on the OrderNum and ItemNum fields is "PRIMARY KEY (OrderNum, ItemNum)". Option A is incorrect because "OrderLine" is not a field in the table. Option B is incorrect because it only specifies the key without indicating it as a primary key. Option D is also incorrect because it is missing the word "KEY" before the field names.

​To Create the Primary Key Clause for the OrderLine Table

To Create the Primary Key Clause for the OrderLine Table