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

Data table as parameter in sql server?

Do you know what are different types of replication in sql server?

What's the difference between a primary key and a unique key?

Does a sql server 2005 select statement require a from?

What is a constant or literal in ms sql server?

how to take backup bcp out for a column in table in sql server?

What is the meaning of resultset type_scroll_insensitive?

What are the Pre Requisites when you apply Srvice Packs?

How to grant a permission in ms sql server using "grant execute" statements?

Which trace flags are enabled in sql server?

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

What is the difference between Clustered and Non-Clustered Index?

For more SQL Server Interview Questions Click Here