1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Explain the difference between clustered and non-clustered index?

Question Posted / nagaraju


Explain the difference between clustered and non-clustered index?..

Answer / Nitin Rana

A Clustered Index determines the physical order of data in a table, while a Non-Clustered Index stores the indexed columns along with a pointer to the actual data row. A table can have only one Clustered Index, but it can have multiple Non-Clustered Indexes.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1 Answers  

wat new abt truncate in sql server

2 Answers   HCL, HP,

What is data source object?

1 Answers  

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

What is 2nf normalization?

1 Answers  

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

What are different types of raid levels?

1 Answers  

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1 Answers  

How can I create a table from another table without copying any values from the old table?

3 Answers  

Can two different columns be merged into single column? Show practically?

1 Answers   QuestPond,

For more SQL Server Interview Questions Click Here
Categories