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 / altaf ali

primary key of a relation is a candidate key that has been
designated as the main key.It doesn't has null value.

A foreign key is an attribute in a relation that can be
used as a key to another relation.It allow null and
duplicate value.

Is This Answer Correct ?    16 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2424


Explain a segment?

1084


Can I create users through internet explorer in oracle 10g?

1083


What are joins, explain all types of joins?

2299


What is recovery manager(rman) backup in Oracle?

1183


What is Library Cache in Oracle?

1142


How to create lov dynamically at runtime & attach to text field?

1194


What is archive log in Oracle?

1134


How to define a cusotmer as a supplier in ORACLE R12

2230


How to create a new tablespace in oracle?

987


What is query image?

981


Explain overloading. Can functions be overloaded?

986


Explain what are the type of synonyms?

1111


what happened to the global index when I truncate the data in one of the partition?

2022


what are steps for interface? where is exchange rate defined in which table?

2158