Which five code segments should you use?

DRAG DROP
You create a disk-based table that contains the following script:

You need to prevent duplicate values in the SKU 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.
Select and Place:

DRAG DROP
You create a disk-based table that contains the following script:

You need to prevent duplicate values in the SKU 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.
Select and Place:

Answer:

Explanation:
Box 1: ALTER TABLE dbo.Products
Box 2: ADD CONSTRAINT
Box 3: CK_SKU
Box 4: UNIQUE
Box 5: (SKU)
Note: The SQL command is:
ALTER TABLE <tablename> ADD CONSTRAINT
<constraintname> UNIQUE
(
<columnname>
)



Leave a Reply 0

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