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:

Remote Location

A place situated far from the main centers of population and often difficult to access.

Management By Walking Around

Managers intermingling freely with workers on the shop floor or in the office, as well as with customers.

Horizontal Communication

The exchange of information, ideas, and messages between individuals or departments on the same level within an organization.

Open Office Space

A layout for offices that eliminates most dividing walls and private offices to create a more collaborative and less hierarchical environment.