Can we have two clustered index on a table?



Can we have two clustered index on a table?..

Answer / Prachi Sonkar

No, a table can only have one Clustered Index per partition key. However, a table can have multiple Non-Clustered Indexes.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How to know the last executed procedure?

1 Answers  


Give the order of sql select?

1 Answers  


Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,


How does an execution block start and end in pl sql?

1 Answers  


Which join is default?

1 Answers  


State the advatage and disadvantage of Cursor's?

2 Answers  


Why do you partition data?

1 Answers  


What is union and union all keyword in sql?

1 Answers  


Which language is used in sql?

1 Answers  


what is a database lock ? : Sql dba

1 Answers  


Which one is better sql or oracle?

1 Answers  


What is implicit cursor in pl sql?

1 Answers  


Categories