Which of the following illustrates the authors' preferred style of defining a primary key?
A)CREATE TABLE CUSTOMER (
CustomerID Integer Primary Key
LastName Char(35)Not Null
First Name Char(25)Null
B)CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35)Not Null
First Name Char(25)Null
CONSTRAINT CustomerPK PRIMARY KEY (CustomerID)
C)CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35)Not Null
First Name Char(25)Null
D)either B or C
E)The author does not demonstrate a preference for how to define a primary key.

Question

Quizplus · Accepted Answer

The authors' preferred style of defining a primary key includes adding the constraint separately, as shown in option B, rather than just including "Primary Key" in the column definition, as shown in option A. Option C is also correct, but option B adds an extra layer of explicitness by including "CONSTRAINT" and the name of the primary key.

Which of the Following Illustrates the Authors' Preferred Style of Defining