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

What is the difference between translate and replace in oracle?

638


What is system tablespace?

619


Can you assign multiple query result rows to a variable?

539


What is merge statement used for?

557


How to rename an index?

575






What are internal user account in oracle?

563


How to invoke the data pump import utility?

638


Explain about the analyze command in oracle?

571


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1430


What is raw datatype?

583


How to find the duplicate rows count from employees table in oracle?

537


Write a trigger example in oracle?

561


What is oracle host variable?

526


How to declare a local variable?

585


How to install oracle database 10g xe?

556