Discussion :: DBMS MCQs
- 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
|
Whatsapp
Facebook
Answer : Option B
Explanation :
Clustered index is built by default on unique key columns
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.
Be The First To Comment