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 changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

What is filestream?

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

What is ms sql server index?

What is dynamic cursor in SQL SERVER?

What are number line correlation administrators will use while working with a subquery?

What kind of problems occurs if we do not implement proper locking strategy?

What is merge join?

What are ddl (data definition language) statements for tables in ms sql server?

Can you roll back the ddl statement in a trigger?

Where cross join is used?

Does sql server use t sql?

For more SQL Server Interview Questions Click Here