DRAG DROP
You create a table that contains the following script:
You need to prevent duplicate values in the EmployeeID field.
Which five code segments should you use?
To answer, move the appropriate code segments from the list of code segments to the
answer area and arrange them in the correct order.
Answer: 
Correct answer:
ALTER TABLE dbo.Customers
ADD CONSTRAINT
CK_EmployeeID
UNIQUE
(EmployeeID)
0
0
Exactly correct
0
0
ALter table cust. add cons. unique(colm nm)
0
0
You should give your constraint a name.
http://stackoverflow.com/questions/1397440/what-is-the-purpose-of-constraint-naming
0
0
Correct answer:
ALTER TABLE dbo.Customers
ADD CONSTRAINT
CK_EmployeeID
UNIQUE
(EmployeeID)
0
0
I agree
0
0