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