Indexes Interview Questions

• Difference between char and nvarchar / char and varchar data-type?

• Difference between Index defrag and Index rebuild?

• Disadvantage of index?

• Explain about Clustered and non clustered index? How to choose

• Given a scenario that I have a 10 Clustered Index in a Table to all

• GUID datasize?

• How can I enforce to use particular index?

• How GUID becoming unique across machines?

• What are statistics, under what circumstances they go out of date,

• What are the data types in SQL

• What is fillfactor? What is the use of it ? What happens when we

• What is Index Tuning?

• What is Index? It’s purpose?

• What is sorting and what is the difference between sorting &

Posted in: