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 the difference between primary key & foreign key?

Answer Posted / suraj menon

primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.

Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to pass parameters to procedures?

975


What is a trigger and what are its types in oracle?

1001


What privilege is needed for a user to create views in oracle?

981


What types of joins are used in writing subqueries?

939


What is primefaces used for?

1009


Explain about integrity constraint?

1079


What is oracle instant client?

973


What is parameterized cursor in oracle?

1068


What happens to the data files if a tablespace is dropped?

996


How to start an oracle instance?

953


Can multiple cursors being opened at the same time?

1018


How to define an anonymous block?

1075


Explain the different normalization forms?

1012


Use of an integrity constraint is better to validate data. Explain

979


how to handle exceptions in post production

1362