Given the SQL Statement

question 25

Multiple Choice

Given the SQL statement
CREATE TABLE SALESREP (
SalesRepNo int NOT NULL,
RepName char(35) NOT NULL,
HireDate date NOT NULL,
CONSTRAINT SalesRepPK PRIMARY KEY (SalesRepNo) ,
CONSTRAINT SalesRepAK1 UNIQUE (RepName)
) ;
We know that ________.

• A)RepName is the primary key
• B)RepName is a foreign key
• C)RepName is a candidate key
• D)RepName is a surrogate key
• E)None of the above is true

---

Definitions:

Lorde

A reference likely to Audre Lorde, a Caribbean-American writer, radical feminist, womanist, lesbian, and civil rights activist known for her work on race, gender, and sexuality.

Test And Learn

A method that involves experimenting with ideas to gather data and insights for making informed decisions.

Experimentation

The process of conducting trials to test hypotheses, explore new ideas, or validate the effects of changes.

Established Companies

Firms that have been in business for a significant period and have developed a stable, profitable business model.