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

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

whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity.

Is This Answer Correct ?    155 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give syntax for SQL and ORACLE joins.

1095


How to get a list of all user accounts in the database?

1090


What is null value in oracle?

1098


How to write a query with a right outer join in oracle?

1169


How to view the tablespaces in the current database?

981


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

2122


What is varray?

1142


What privilege is needed for a user to create views in oracle?

1053


What are joins, explain all types of joins?

2299


Query to retrieve record for a many to many relationship ?

2521


Explain compound trigger in oracle?

1045


What is a proxy class?

1059


List the types of joins used in writing subqueries?

998


Difference between oracle's plus (+) notation and ansi join notation?

1108


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1935