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:

Expertise

Advanced knowledge or skill in a particular field, acquired by experience, study, or training.

Peripheral-Route Processing

A method of persuasion that relies on superficial cues and heuristics, such as the attractiveness of the speaker, instead of the quality of the argument.

Credible

Being believable or worthy of trust based on evidence or reasoning.

Central Route

A method of persuasion that involves deep thinking and the logical processing of information, leading to lasting attitude change.