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:

Metric Equivalent

A system of measurement that provides conversions between the metric system units and other measurement units.

Liters

A metric unit of volume equal to 1,000 cubic centimeters or approximately 0.26 U.S. gallons.

Coffee

A beverage made from roasted and ground beans of the Coffea plant, widely consumed globally for its stimulating effect due to caffeine content.

Juice

A liquid that is naturally contained in fruit and vegetables, often consumed as a beverage.