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

Question

Quizplus · Accepted Answer

RepName is defined as a UNIQUE constraint (SalesRepAK1), which means it is a candidate key. The primary key is SalesRepNo. None of the columns are defined as foreign or surrogate keys.

Given the SQL Statement CREATE TABLE SALESREP