Given the SQL Statement CREATE TABLE SALESREP

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