what is the difference between primary key & foreign key?

Answer Posted / raji

foregin key reference a primary key in another table

and primary key is used to identify a row.

Is This Answer Correct ?    30 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please explain oracle data types with examples?

584


What is backup in Oracle?

567


What is rowid and rownum in oracle?

541


Use of an integrity constraint is better to validate data. Explain

543


How to use fetch statement in a loop?

551






Explain drop constraint oracle?

589


How to join two tables in a single query using oracle?

564


How to insert a record into a table?

634


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1823


What is an oracle data file?

611


Where is the export dump file located?

567


Give the various exception types.

542


Explain the characteristics of oracle dba?

636


Explain the difference between sap and oracle?

570


How to connect the oracle server as sysdba?

627