what is difference between foreign key and reference key

Answer Posted / soujanya

Foreign key is the key i.e. attribute which refers to
another table primary key. Reference key is the primary key
of table referred by another table.

Is This Answer Correct ?    37 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why should I use oracle database?

566


What is the difference between online and offline backups?

558


How to do paging with oracle?

566


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1517


What is the implicit cursor in oracle?

557






Explain oracle instance.

677


What is a named program unit?

575


What are the various constraints used in oracle?

546


What is the usage of save points in oracle database?

530


What is the use of aggregate functions in oracle?

572


How to define a specific record type?

609


What are the restrictions in a oracle read only transaction?

559


What is a dead lock in oracle?

584


Please explain compound trigger in oracle?

590


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

1799