Which one is true about clustered index? Options: A . &nbspClustered index is not associated with table B . &nbspClustered index is built by default on unique key columns C . &nbspClustered index is not built on unique key columns D . &nbspNone of the mentioned

Which one is true about clustered index?

Question

Which one is true about clustered index?

Options:

A . Clustered index is not associated with table

B . Clustered index is built by default on unique key columns

C . Clustered index is not built on unique key columns

D . None of the mentioned

Answer: Option B

Clustered index is built by default on unique key columnsNonclustered indexes have a structure separate from the data rows. A nonclustered index contains the nonclustered index key values and each key value entry has a pointer to the data row that contains the key value.

Was this answer helpful ?

Next Question