what is the difference between primary key & foreign key?

Answer Posted / bharathi sundar

A PRIMARY KEY DOES NOT ACCEDES DUPLICATIONS .
A FOREIGN KEY IS USED FOR LINKING TWO DATABASE TABLES
ABSTRUSELY .

A FOREIGN KEY USES THE PRIMARY KEY IN ANOTHER TABLE,
TO RETRIEVE OR TO IDENTIFY THE CELL VALUES IN ANOTHER
TABLE.........

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does facebook use oracle?

581


How to export data to a csv file?

627


How to delete a column in an existing table?

595


IS it possible to built the oracle database without setting the kernal parameters?

1763


What do you mean by a deadlock?

519






What is a data dictionary and how can it be created?

617


What is data file?

619


How to create a new table in oracle?

593


What is the difference between sharding and replication?

479


how to do daily transactions with out sql* loader control file regesterd in apps?

1224


How to create a testing table in oracle?

547


What is recovery manager(rman) backup in Oracle?

629


How do I find the database name in oracle?

603


How does one get the view definition of fixed views/tables?

606


What happens in oracle commit?

572