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 drop an existing table in oracle?

1056


What is bulk load in oracle?

1068


Can we insert data in view oracle?

1015


What is the difference between pre-select and pre-query?

1211


How do you find current date and time in oracle?

1045


What are the system predefined user roles?

1041


How to download oracle database 10g xe?

1013


Can a formula column be obtained through a select statement ?

2316


What is private procedure oracle?

1006


How to upsert (update or insert into a table)?

997


What is a package in oracle?

1098


What is the oracle implicit cursor?

1058


Explain how you would restore a database using RMAN to Point in Time?

2141


What is a parameter file in oracle?

1131


What happens to the indexes if a table is recovered?

989