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

Multiple Choice

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
) ;
ALTER TABLE CUSTOMER
ADD CONSTRAINT CustomerPK PRIMARY KEY (CustomerID) ;
D) Both B and C are correct