PrepAway - Latest Free Exam Questions & Answers

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.

PrepAway - Latest Free Exam Questions & Answers

Answer: See the explanation

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>
)

One Comment on “Which five code segments should you use?


Leave a Reply