what is the difference between primary key & foreign key?

Answer Posted / vasavi

primary key does not allow duplicate and null values
primary is unquie.

foreign key allows null values it refers primary key.

foreign key allows duplicate values.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2058


What is the parameter mode that can be passed to a procedure?

569


What is different types of joins?

570


What is a oracle database?

605


Explain the use of grant option in exp command.

586






What is a subquery in oracle?

576


What is rich query?

540


What are the differences between primary key and unique key?

509


How to export several tables together?

564


What is oracle server autotrace in oracle?

613


How to create a new table in oracle?

589


Is java required for oracle client?

548


How would you begin to troubleshoot an ORA-3113 error?

1601


What are set operators?

644


What is open database communication (odbc) in oracle?

545