Which five code segments should you use?

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.

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:



Leave a Reply 6

Your email address will not be published. Required fields are marked *


HR_OS_B

HR_OS_B

Correct answer:
ALTER TABLE dbo.Customers
ADD CONSTRAINT
CK_EmployeeID
UNIQUE
(EmployeeID)

Mido

Mido

Exactly correct

Jai

Jai

ALter table cust. add cons. unique(colm nm)

WK

WK

Correct answer:
ALTER TABLE dbo.Customers
ADD CONSTRAINT
CK_EmployeeID
UNIQUE
(EmployeeID)