What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
Answer Posted / leena
clustered index physically store data orderly in a
table,but non-clustered index store data logically not
physically.
primary key is by default clustered index,and unique key is
by default non-clustered index.
A table can contain only one cluster index.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How can we implement rollback or commit statement in a trigger?
What is group function in sql?
Is sql low level language?
Write the alter statement to enable all the triggers on the t.students table.
Is keyword pl sql?
List the ways to get the count of records in a table?
What are database links used for?
Explain the structure of pl/sql in brief.
How would you convert date into julian date format?
how do you know if your mysql server is alive? : Sql dba
What does cursor do in sql?
How to process query result in pl/sql?
How do I upgrade sql?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How many joins in sql?