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

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1609


How to list all tables in your schema?

597


What is oracle join syntax?

558


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

1951


What are the different oracle database objects?

577






What is Redo Log Buffer in Oracle?

617


What is a dynamic performance view in oracle?

594


What is the difference between a primary key & a unique key?

580


How to use values from other tables in update statements using oracle?

559


How to create tables for odbc connection testing?

485


What are the tools for Oracle ?

595


What is a synonym? What are its various types?

615


What is SQL Tuning Advisor in Oracle?

623


What are the differences between char and nchar in oracle?

589


What is java oracle used for?

521