what is the difference between primary key & foreign key?

Answer Posted / ramprakash

Primary keys enforce entity integrity by uniquely
identifying entity instances. Foreign keys enforce
referential integrity by completing an association between
two entities.

Is This Answer Correct ?    275 Yes 50 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the simplest tool to run commands on oracle servers?

502


How to define a data field as not null?

625


What are the system predefined user roles?

579


Explain a private synonyms?

623


How to download oracle database 10g xe?

586






How to create a stored program unit?

567


What are the differences between interval year to month and interval day to second?

544


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1558


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1606


How to create a new user account in oracle?

567


20. Using a set operator, display the client number of all clients who have never placed an order.

1789


How would you go about verifying the network name that the local_listener is currently using?

1599


Is it possible to split the print reviewer into more than one region ?

1824


What is the difference between sharding and replication?

472


What is hash cluster in oracle?

588