what is clustered index?why is it created?

Question Posted / swapna

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

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?

6 Answers Wipro,

What is the difference between connected and disconnected environment?

0 Answers

What are the three Ado objects?

6 Answers Microsoft, StarSoft,

What is difference between sqldatareader and sqldataadapter?

0 Answers

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

0 Answers

What is connection pooling and what is the maximum pool size in ado.net connection string?

0 Answers

What are the uses of Stored Procedure?