what is clustered index?why is it created?

Question Posted / swapna

4 Answers
13211 Views
Microsoft, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is clustered index?why is it created?..

clustered index is a type oof index this is a physical
component used to to resorted the data in a table. U can use
only one clustered index for a Table.

Is This Answer Correct ?

14 Yes

2 No

what is clustered index?why is it created?..

Answer / roopesh kumar

Clustring is a method for storing the tables in same block
that are related.
Cluster index are used to achive this object.

Is This Answer Correct ?

9 Yes

1 No

what is clustered index?why is it created?..

Answer / amit

Clustered index is the primary key of the table...

Is This Answer Correct ?

6 Yes

5 No

what is clustered index?why is it created?..

Answer / kuldeep kumawat

clustered index make physical table of the underline base table like (PhonBook,Discretionary)
and
Non clustered index is a reference table key of base table.
nonclusterd index has reference key to point a main table record
(like our not book we have index at first page and page number )
Example blow here ..
topics page no
class 20
object 30
asp.net 300
practices Example 330

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE

2 Answers

What is datasource in ado.net?

0 Answers

Give an example of a .net application which connects to microsoft access database using ado.net classes.

0 Answers

What are the rules to implement connection pooling?