Three Type of indexes in sql 1.Clustered 2.Non-clustered 2.Primary XML

How many types of indexes are there in SQL Server?

Question Posted / chandra bhan singh

Answer Posted / chandra bhan singh

Three Type of indexes in sql

1.Clustered
2.Non-clustered
2.Primary XML

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

973

What do you mean by an execution plan? Why is it used? How would you view it?

922

What is transaction server explicit transaction?

1026

How to declare and use cursor variables?

1155

What is query processing?

929

What is save transaction and save point?

1194

Write a SQL command to insert and update only a particular field?

1098

What are diverse clauses that form a part of sql?

1063

What is the significance of master, tempdb and model databases?

1071

Does a specific recovery model need to be used for a replicated database? : sql server replication

950

What is enhanced database mirroring in sql server 2008?

962

What are the advantages of passing name-value pairs as parameters?

1160

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

978

Does any body please help me what question's have asked for SSRS in the interview?

2143

Explain the cursor lock types?

1043