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
Is full outer join same as cross join?
State few characteristics of pl/sql?
When should I use nosql database?
How do I turn a list into a table?
what is the difference between a having clause and a where clause? : Sql dba
What does stand for in sql?
What does where 1 1 mean in sql?
Is join same as left join?
What is a database event trigger?
Define a temp table?
What is Materialized View? In What Scenario we Use Materialized View?
what is acid property in database? : Sql dba
What is scope of pl sql developer in future?
How can you load multi line records? : aql loader
What is exit statement?