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 / suraj menon

primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.

Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why should I use oracle database?

987


What happens if you use a wrong connect identifier?

1057


What are the different editions of oracle?

1105


Why do you create or replace procedures rather that drop and recreate.

1003


Is insert autocommit in oracle?

1065


ABOUT IDENTITY?

2053


What is the relationship among database, tablespace and data file?

985


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4519


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2220


if you ctreate table identity

2368


Explain the use of owner option in exp command.

1041


What happens to the current transaction if the session is ended?

1094


What is bind variable in oracle 11g?

1037


What is a subquery?

1120


What is a schema in oracle?

1010