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
E) None of the above is true
Correct Answer:

Verified
Correct Answer:
Verified
Q5: Rows in a table can be changed
Q20: SQL triggers are used for _.<br>A)validity checking<br>B)providing
Q21: The following database will be used in
Q24: Based on the tables below,which of the
Q26: Which of the following is an SQL
Q28: Which SQL keyword is used to name
Q29: Which SQL keyword is used to change
Q56: The SQL SET keyword is used to
Q59: The SQL command SELECT is used to
Q100: The SQL Server DBMS supports the SQL