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 are the advantages of primary key over unique+notnull

Answer Posted / soubhagya

When we create a primary key automatically a cluster index
is created on those columns involved in primary key.But
this index not created in unique+not null key, it only
restrict the duplicate values.

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of stored procedures?

1074


What is a primary key? Explain

976


Does sql full backup truncate logs?

1020


What are different clauses used in sql?

1117


What does pl sql developer do?

935


What is sql performance tuning?

924


how to drop an existing index in mysql? : Sql dba

1069


What is the difference between sql, mysql and sql server?

1109


What is java sql drivermanager?

1102


How do I save a sql query?

1018


What are sql data types?

1032


How do you use collections in procedure to return the resultset?

2243


What are sql built in functions?

939


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1041


How do I install microsoft sql?

1055