what is the difference between primary key & foreign key?

Answer Posted / harish

primary key does not allow duplicate and null values
but foreign key allows null values it refers primary key

Is This Answer Correct ?    25 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write an inner join with the where clause in oracle?

585


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2178


What do you mean by merge in oracle and how can we merge two tables?

577


What are oracle functions?

555


Explain drop constraint oracle?

593






Is postgres faster than oracle?

561


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

614


How to use group functions in the select clause using oracle?

595


How different is ms access and oracle?

547


How will you write a query to get a 5th rank student from a table student_report?

1378


What is dynamic proxy?

554


What is the oracle implicit cursor?

596


How to install oracle odbc drivers?

625


How to pass parameters to procedures?

555


Is there an oracle sql query that aggregates multiple rows into one row?

546