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

About types of indexes in SQL server ?

Question Posted / pandian

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What do you understand by mirroring and mention the advantages of the mirroring?

1114

How to find the second highest salary of an employee?

1222

Give an example of SQL injection attack ?

1050

What are the new data types are introduced in sql 2000?

949

what's the maximum size of a row? : Sql server database administration

1163

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

1050

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

1102

What is sub-query in sql server? Explain its properties.

1133

How can sql server instances be hidden?

1029

What is user-defined scalar function?

1009

Define ACID properties in a Database?

1103

Is sql server a database?

1040

What is a join in sql?

1155

What are the disadvantages of primary key and foreign key in SQL?

1151

Do you know how to store and query spatial data?

1087