Question:
For every unique constraint on a column, SQL server will create:

Option A):
clustered index for that column
Option B):
index for that column
Option C):
Does not create any index
Option D):
non-clustered index for that column

Correct Answer is Option D):
non-clustered index for that column