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

Options
- Does not create any index
- clustered index for that column
- index for that column
- non-clustered index for that column


CORRECT ANSWER : non-clustered index for that column

Discussion Board
Nonclustered index

For every unique constraint on a column, SQL server will create non-clustered index for that column. A nonclustered index is an index structure separate from the data stored in a table that reorders one or more selected columns.

Prajakta Pandit 03-10-2017 06:48 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement