1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What is the difference between clustered and non-clustered index? : sql server DBA

Question Posted / navneet kaur


What is the difference between clustered and non-clustered index? : sql server DBA..

Answer / Akhand Pratap Kaushal

A clustered index determines the physical order of data in a table, and there can be only one clustered index per table. A non-clustered index is a separate structure that contains the indexed columns' values and a reference to the corresponding row location in the table. Non-clustered indices support multiple indexes per table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

What is transparent data encryption? : sql server DBA

1 Answers  

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1 Answers  

what is rebuild index??

2 Answers   IBM, Sapient,

what is ora 24313?what is the procedure to exclude that error?

1 Answers  

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

Explain about your sql server dba experience? : sql server DBA

1 Answers  

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1 Answers  

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

How do you resize a data file?

2 Answers  

Where would you look for errors from the database engine?

1 Answers   IBM,

For more DB Administration Interview Questions Click Here
Categories