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

Primary key is a keyword.
It should not have null value and duplicate value.
We can have only one primary key in a table and the value
should be unique.

Foreign key is a keyword.
It can have null value and duplicate value.
We can have more than one foreign key for a table and this
froeign key table references the primary key table.

Is This Answer Correct ?    22 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please explain joins in oracle?

1009


Is postgres faster than oracle?

972


What is literal?

957


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2247


How to call a sub procedure?

1036


Can we store images in oracle database?

948


What is the data type of dual table?

921


Why packages are used in oracle?

1002


What is max rowid in oracle?

966


What is oracle and what are its different editions?

1008


What is tns name?

928


Explain the difference between a procedure and a function?

1091


what is the scenario where you take the database to NoArchivelog mode?

2259


Can we connect to ORACLE db using Windows Authentication?

1183


can anyody please send me the dump for Oracle 10g certifications for DBA path?

2090