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?

1062


How to best split csv strings in oracle 9i?

1041


How to define an anonymous procedure with variables?

1158


Is oracle a relational database?

916


What is data file?

1103


What is Segment Advisor in Oracle?

1103


How to get execution statistics reports on query statements?

1094


Explain cascading triggers.

1073


How to rename a column in an existing table?

1035


How will you write a query to get a 5th rank student from a table student_report?

1866


How to convert characters to dates in oracle?

1099


What is the difference between $oracle_base and $oracle_home?

1089


What is dual table oracle?

984


What is tns entry?

1151


What is ordinary table in oracle?

1156