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

Question

Quizplus · Accepted Answer

The PRIMARY KEY clause should be followed by the name of the table and then the fields that should be the primary key. Option C uses the correct syntax and specifies the OrderNum and PartNum fields as the primary key for the Orders table. The other options are incorrect syntax or use incorrect field names or table names.

To Create the Primary Key Clause for the Orders Table