Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What are the different index configurations a table can have?

A table can have one of the following index configurations,
 
1. No indexes
2. A clustered index
3. A clustered index and many non-clustered indexes
4. A non-clustered index
5. Many non-clustered indexes



Next 5 interview question(s)

1
Which TCP/IP port does SQL Server run on? How can it be changed?
2
Explain Transact-SQL optimization tips?
3
What is Foreign key?
4
How can a programmer enforce to use particular Index?
5
Explain the joins in SQL Server?