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

Question

Quizplus · Accepted Answer

RepName is marked as a UNIQUE constraint which makes it a candidate key, but it is not the primary key. The primary key is SalesRepNo. Therefore, option A and D are incorrect. There is no indication that RepName is a foreign key, so option B is incorrect as well. Therefore, the correct answer is C.

Given the SQL Statement