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

How can we implement rollback or commit statement in a trigger?

1085


What is group function in sql?

1067


Is sql low level language?

1066


Write the alter statement to enable all the triggers on the t.students table.

1175


Is keyword pl sql?

1057


List the ways to get the count of records in a table?

942


What are database links used for?

1095


Explain the structure of pl/sql in brief.

1139


How would you convert date into julian date format?

1044


how do you know if your mysql server is alive? : Sql dba

1128


What does cursor do in sql?

1067


How to process query result in pl/sql?

1201


How do I upgrade sql?

1051


what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019


How many joins in sql?

1058