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

question 7

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

---

Definitions:

Factory Equipment

Assets such as machinery and tools used in the manufacturing process to produce goods and services.