what is clustered index?why is it created?

Question Posted / swapna

4 Answers
11496 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 the use of SqlCommand object?

0 Answers

explain connection less and with connection?diference between data reader,data set,data adapter? can we use data reader,data set in a single application? if yes explain with simple code,if no explain?

3 Answers Techno Labs,

How many major types of connection objects in ADO.NET?

0 Answers MCN Solutions,

What is the difference between data reader and data adapter?

0 Answers

Define isolation?

0 Answers

Does executenonquery return a value?

0 Answers

What is the meaning of executenonquery?

0 Answers

what is Sql Native Client?