what is the difference between primary key & foreign key?

Answer Posted / ibrahim

primay key uniquely identifies records in relation.
in a table only one primary key.But may have more than one
foreign key.

Is This Answer Correct ?    14 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is recovery manager(rman) backup in Oracle?

624


Can objects of the same schema reside in different tablespace?

584


What is a cursor in oracle?

644


How to insert a record into a table?

636


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1435






Explain oracle data types with examples?

575


How to Truncate Table in Oracle

653


What is bulk load in oracle?

589


What is oracle instant client?

564


What is backup in Oracle?

567


How to create a server parameter file?

571


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1803


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

520


What is rowid and rownum in oracle?

541


Explain a data segment?

646