what is the difference between primary key & foreign key?

Answer Posted / raghu

In the context of relational databases, a foreign key is a
referential constraint between two tables.[1] The foreign
key identifies a column or a set of columns in one
(referencing) table that refers to a column or set of
columns in another (referenced) table. The columns in the
referencing table must form a primary key or unique key.

Is This Answer Correct ?    58 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

 What are the oracle DML commands possible through an update strategy?

582


What are data pump export and import modes?

611


What are the limitations of check constraint?

573


What is an oracle?

577


Explain the use of owner option in exp command.

569






How to use "in out" parameter properly?

613


Can a formula column be obtained through a select statement ?

1845


How to build data dictionary view an new database?

532


How to convert csv to table in oracle?

528


What are advantages of dateset in datastage?

1747


How to connect to the server with user account: sys?

565


Is oracle a language?

522


How to grant create session privilege to a user in oracle?

572


What is object data modeling?

507


Explain oracle insert into command?

631