Given the SQL Statement CREATE TABLE SALESREP

question 62

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

---

Definitions:

Core Principles

Core principles are fundamental beliefs or values that guide the behavior and practices of an individual or organization.

Detail Salesperson

A sales professional specialized in providing extensive and meticulous information about a product or service.

Order-Taker

A salesperson whose primary role is to take orders from customers, rather than actively sell or promote products.

Sales Engineer

A professional who leverages technical and engineering expertise to sell complex technological products or services, often requiring customization or significant explanation.