Sqlserver Interview questions

Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What are the difference between clustered and a non-clustered index?

A clustered index:-
A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

A non clustered index:-
A non-clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on the disk. The leaf node of a non-clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Next 5 interview question(s)

What is the difference between a primary key and a unique key?
What is NOT NULL Constraint?
What is Check Constraint?
What is Unique key constraint?
What is a Primary key?