what is clustered index?why is it created?

Question Posted / swapna

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

Explain how to find the given query is optimised one or not?

0 Answers

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

0 Answers

Explain the two fundamental objects in ado.net?

0 Answers

What is the difference between ADO and ADO.Net?