Question

A table (sql server) has 10 columns. 2 columns : uniqueidentifier/guid, unique, not null 2 columns : int, unique, not null 2 columns : varchar, unique, not null 2 columns : varchar, not null 2 columns : varchar, null how many clustered index can be created on the table?

Answer 1

Clustered index is a type of index that deals in reordering of the way records are physically stored in a table.

A single table can have only one clustered index. These are efficient in case of columns when searched for a large range of values.

It is very important concept and must be understood properly.