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

i cleared this question simple.

TAKE A LOOK

primary key:-It doesn't allow NULL values and duplicate values
it is a unique one.


Foreign key:- It allows NULL and duplicate values
It always give reference to primary key of another 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 convert csv to table in oracle?

990


What is background process in Oracle?

1101


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2137


What is a proxy object?

1062


Why do you create or replace procedures rather that drop and recreate.

1006


How to call a stored function in oracle?

1018


What are the ways tablespaces can be managed and how do they differ?

2367


What are nested tables?

1174


How to estimate disk space needed for an export job?

1050


Can multiple cursors being opened at the same time?

1060


What is PL/SQL ?

2063


How to add another datafile to a tablespace?

1040


What is a view and how is it different from a table?

1045


How do you bind variables in oracle?

980


What are the predefined tablespaces in a database?

1081