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

we are able to create a primary key for combination of more
than 1 column. which is not possible in Unique,we should
create unique key for each and every column in the table
individually.

ex . we can create a primary key for (Name,DOB,address)- ie
combination of these three columns be unique.

Is This Answer Correct ?    3 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are character functions?

1139


How do you rename a table in sql?

1184


What is the difference between Union and Union all. Which is faster.

1439


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

1016


How many sql core licenses do I need?

994


Is sql easier than java?

1069


what is difference between delete and truncate commands? : Sql dba

1170


What is field delimiter?

1111


how mysql optimizes distinct? : Sql dba

1123


How to pronounce postgresql?

1096


Why do we use sql constraints?

1213


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1300


what is union? : Sql dba

1080


what is a view? : Sql dba

1132


What are expressions?

1062