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...

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


Please Help Members By Posting Answers For Below Questions

define sql insert statement ? : Sql dba

1031


What is sqlerrd?

968


How to rename a table?

1023


What is the difference between the sql*loader and import utilities? : aql loader

1043


What is a scalar value in sql?

1073


Is a secondary key the same as a foreign key?

1038


What is sqlca in db2?

971


What is normalization in a database?

1159


What is an inner join sql?

1029


What is triggering circuit?

1067


Why do we go for stored procedures?

1057


Does oracle roll back the transaction on an error?

1014


Write a unique difference between a function and a stored procedure.

998


how many ways we can we find the current date using mysql? : Sql dba

1099


What is rtm in testing?

1117