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 is the maximum number of triggers that can be applied to a single table?

953


Explain an exception and its types?

1008


What is oracle server autotrace in oracle?

1088


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

993


How to list all indexes in your schema?

1030


what are the default admin accounts in Oracle 10g ?

916


How to check database size in Oracle?

1115


How to create a new table in oracle?

1064


What is rowid and rownum in oracle?

951


What is not equal to in oracle?

951


How many categories of data types in oracle?

953


What is the data type of dual table?

918


How to assign query results to variables?

1010


What to do if dba lost the system password?

1086


Why do you use stored procedures and state some of its disadvantages?

967