To create the primary key clause for the Customer table on the CustomerNum field,the correct statement is ____.
A) PRIMARY KEY (CustomerNum)
B) PRIMARY KEY (Customer, CustomerNum)
C) KEY (CustomerNum)
D) PRIMARY (CustomerNum)

Question

​To create the primary key clause for the Customer table on the CustomerNum field,the correct statement is ____.
A) ​PRIMARY KEY (CustomerNum)
B) ​PRIMARY KEY (Customer, CustomerNum)
C) ​KEY (CustomerNum)
D) ​PRIMARY (CustomerNum)

Quizplus · Accepted Answer

A primary key is a unique identifier for each record in a table. In this case, the CustomerNum field is being used as the primary key, and it should be specified using the PRIMARY KEY clause. Option A correctly specifies the CustomerNum field as the primary key. Option B is incorrect because it references two fields, when only the CustomerNum field is being used as the primary key. Option C is incorrect because it uses the KEY keyword instead of PRIMARY KEY. Option D is incorrect because it is missing the KEY keyword before the field name.

​To Create the Primary Key Clause for the Customer Table

To Create the Primary Key Clause for the Customer Table