About types of indexes in SQL server ?

Question Posted / shaheen

Answers were Sorted based on User's Feedback

About types of indexes in SQL server ?..

Answer / pandian

There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)

Is This Answer Correct ?

9 Yes

3 No

About types of indexes in SQL server ?..

Answer / bala

Filtered Index in case of SQL Server 2008

Is This Answer Correct ?

0 Yes

3 No

More SQL Server Interview Questions

What is data modeling and Reterminal integrity?

What is difference between clustered and non clustered index?

How to skip remaining statements in a loop block using continue statements?

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

What is change data capture (cdc) feature?

What is serializable?

what stored procedure would you use to view lock information? : Sql server administration

Explain the rules for designing files and file groups in sql server?

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

What are SQL Jobs, please mention the use of it and how to create them.

Can you explain the disadvantages/limitation of the cursor?

Explain the properties of a relational table?

For more SQL Server Interview Questions Click Here