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:

Fraternal Birth-order Effect

A theory suggesting that the more older brothers a man has, the higher the probability is of him being homosexual.

Fetus

A developing mammal or human from the end of the embryonic stage until birth.

Hormones

Chemical substances produced by glands in the body that regulate the activity of cells or organs, influencing growth, mood, and metabolic processes.

Expressive Behaviors

Actions that communicate an individual's emotional state or intentions to others, ranging from facial expressions to body movements.