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 difference between foreign key and reference key

Answer Posted / anup

very simple...we use primary key or foreign key whenever we need to make relation.ex..if we need to join student (Roll P.K) and marks(roll F.K.) then we can join both tables only if we have primary key in one table and foreign key in other..one table may have n numbers of foreign key and n number of primary key (Called composite key)..mail me if u need more details in oracle or any front end lang...anup from chennai,Ranchi.

Is This Answer Correct ?    8 Yes 27 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the major difference between truncate and delete?

1058


What is dynamic proxy?

1005


How to create an oracle testing table?

1069


Why do we use bulk collect in oracle?

1058


How to turn on or off recycle bin for the session?

1109


What are the differences between char and varchar2 in oracle?

1170


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2178


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5410


What is a procedure in oracle?

1196


How do we create privileges in oracle?

1045


How to create a table index in oracle?

1133


Why does Oracle not permit the use of PCTUSED with indexes?

2424


What is Redo Log Buffer in Oracle?

1207


What is meant by a deadlock situation?

1109


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1985