What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?

Answers were Sorted based on User's Feedback



What is clustered, non-clustured and unique index. How many indexes can be created on a table ?..

Answer / rajkumar

please don't give oracle answers in sqlserver

Is This Answer Correct ?    12 Yes 8 No

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?..

Answer / 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

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?..

Answer / amit

A clustered index are those which created by user manually
and non clustered are automatically created by oracle server
when we create a primary key or a unique key on a column.

and as many as indexes can be created on table but it will
reduces the performance of the database.

Is This Answer Correct ?    1 Yes 10 No

Post New Answer

More SQL PLSQL Interview Questions

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,


Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,


What is t-sql? : Transact sql

0 Answers  


Give which cursor is better for better performance means type of cursors?

2 Answers  


Is sqlexception checked or unchecked?

0 Answers  


Explain foreign key in sql?

0 Answers  


Does asenumerable execute the query?

0 Answers  


What is program debugging?

0 Answers  


What is rollback?

0 Answers  


How do I view a procedure in sql?

0 Answers  


Which nosql database is best?

0 Answers  


Explain how can you save or place your msg in a table?

0 Answers  


Categories