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

question 47

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
• D)either B or C
• E)The authors do not demonstrate a preference for how to define a primary key.

---

Definitions:

Effective Interest Method

A technique used in accounting to allocate the interest expense or income of a bond over its lifetime based on the bond's carrying amount at each interest period.

Balance Sheet

A financial statement that summarizes a company's assets, liabilities, and shareholders' equity at a specific point in time.

Effective Interest Method

The effective interest method is a finance and accounting technique used to allocate loan or bond interest expense over the relevant period based on the loan's book value.