Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / wgk

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

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

How can you create an empty table from an existing table?

0 Answers  

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

Can a foreign key be null?

0 Answers  

What is bulk collect in pl sql?

0 Answers  

Can we group by two columns in sql?

0 Answers  

What is sqlcommand?

0 Answers  

which operator is used in query for pattern matching? : Sql dba

0 Answers  

What are the different ways to optimize a sql query?

0 Answers  

Is sqlite free?

0 Answers  

What is dense_rank?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories