PrepAway - Latest Free Exam Questions & Answers

Which two of the following statements are true?

Given the following table definition:
EMPLOYEES
———————-
EMPID INTEGER
NAME CHAR(20)
SALARY DECIMAL(10,2)
If the following SQL statement is executed:
CREATE UNIQUE INDEX empid_ui ON employees (empid)
Which two of the following statements are true?

PrepAway - Latest Free Exam Questions & Answers

A.
Multiple null values are allowed in the EMPID column of the EMPLOYEES table.

B.
No null values are allowed in the EMPID column of the EMPLOYEES table.

C.
One (and only one) null value is allowed in the EMPID column of the EMPLOYEES table.

D.
No other unique indexes can be created on the EMPLOYEES table.

E.
Every value found in the EMPID column of the EMPLOYEES table will be different.

One Comment on “Which two of the following statements are true?


Leave a Reply