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 normalization? Explain different levels of normalization? : Sql server database administration

How can u get the number of pupils connecting the database?

Explain about Joins?

How to connect PK and FK?

Write a sql query to delete duplicate records from a table called table1

What is use of except clause?

Is there any difference between the primary key and unique key?

how to control the amount of free space in your index pages? : Sql server database administration

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

What is the recovery model?

What is dynamic cursor in SQL SERVER?

How can I create a new template for import ? : sql server management studio

For more SQL Server Interview Questions Click Here