what is clustered index?why is it created?

Question Posted / swapna

4 Answers
11511 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

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

0 Answers

What are the different methods available under the sqlcommand class to access the data?

0 Answers

What is the advantage of ado.net?

0 Answers

Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?