Which one is true about clustered index?
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:A
Which one is true about clustered index?
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
Explanation: Nonclustered 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.