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)

1
What is the difference between a primary key and a unique key?
2
What is NOT NULL Constraint?
3
What is Check Constraint?
4
What is Unique key constraint?
5
What is a Primary key?