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 the types of functions in sql?

965


tell me about various levels of constraint. : Sql dba

989


when is the use of update_statistics command? : Sql dba

966


Explain the difference between drop and truncate commands in sql?

957


what is normalization? : Sql dba

1014


Can we use view in stored procedure?

862


Explain character-manipulation functions?

1066


What is the difference between view and stored procedure?

909


What is sqlcommand?

962


how can we submit a form without a submit button? : Sql dba

916


What is oracle sql developer?

987


Explain exception handling in pl/sql?

987


What if we write return in procedure?

1331


Why coalesce is used in sql?

906


how to use case expression? : Sql dba

957