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

Primary is unique one. Each table has only one primary key.
But not allow null values.

Foreign key is opposite of primary. It is reference of
primary key from another table. It allow Null value. Each
table can have more than one foreign key.

Foreign key is used to link one to another table.

Is This Answer Correct ?    22 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bulk collect in oracle?

954


What is a cursor variable?

1044


What is a private synonym?

1529


How to create a new table in oracle?

1065


How to create a table interactively?

996


What are joins, explain all types of joins?

2219


How to define an explicit cursor in oracle?

985


What do you mean by a tablespace?

980


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1590


How to connect to oracle using service name instead of sid?

963


How to define a variable of a specific record type?

1017


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2245


How to change user password in oracle?

974


What is a sub query and what are the different types of subqueries?

1072


What are the four Oracle system processes that must always be up and running for the database to be useable?

954