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

Question

Quizplus · Accepted Answer

The preferred style of defining a primary key is to use the CONSTRAINT keyword to explicitly define the primary key using a named constraint. The syntax in option B uses this preferred style. Option A uses the Primary Key keyword but does not explicitly name the constraint, while option C uses the Add Constraint keyword after the table is created, which is not the preferred method. Option D is incorrect because option C is not the preferred method.

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