what is the difference between primary key & foreign key?

Answer Posted / vaziuddin shaik

PRIMARY KEY
-------------
Primary key is a column in a table which is having unique
values......and it does not contain null values and
duplicate values...........

FOREIGN KEY
-------------
Foreign key is a column in a table which act as reference to
another table.....and it may contain null and duplicate
values.....(or)it may not contain null and duplicate
values...........

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to pass parameters to procedures?

555


How can I combine multiple rows into a comma-delimited list in oracle?

583


What happens to the current transaction if a ddl statement is executed?

580


How to export your own schema?

574


What are the predefined tablespaces in a database?

556






How to load data through external tables?

583


What is literal?

589


What are the differences between number and binary_float in oracle?

571


Why is oracle used?

557


What is set verify off in oracle?

581


How to return top 5 rows in oracle?

550


Can you assign multiple query result rows to a variable?

552


State and explain the different types of data models?

538


How to end the current transaction in oracle?

562


Explain drop constraint oracle?

593