Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between foreign key and reference key
- 3 Answers
- 42240 Views
- AZTEC, Infosys, I also Faced
- E-Mail Answers
Answer Posted / suresh kumar
Hi, i give the definitions with easy understand exapmles
A primary key is used to uniquely identify each row in a
table. It can either be part of the actual record itself,
or it can be an artificial field (one that has nothing to
do with the actual record).
A primary key can consist of one or more fields on a table.
When multiple fields are used as a primary key, they are
called a composite key.
EX:If we take EMP table, Empno is the primary key and in
DEPT table, Deptno is the primary keys
A foreign key is a field (or fields) that points to the
primary key of another table.
The purpose of the foreign key is to ensure referential
integrity of the data.
In other words, only values that are supposed to appear in
the database are permitted
EX:In EMP table Deptno field is the foreign key because it
pointing to the Deptno in DEPT table
A Reference key is a field (or fields) that points to the
primary key of the same table
EX:In EMP table Mgr field is the Reference key because it
pointing to the Empno field in the same table
| Is This Answer Correct ? | 64 Yes | 12 No |
Post New Answer View All Answers
How to commit the current transaction in oracle?
What are the numeric comparison operations?
20. Using a set operator, display the client number of all clients who have never placed an order.
Please explain oracle data types with examples?
How to view all columns in an existing table?
Describe varray?
What is the difference between 10g OEM and 11g OEM?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Is the After report trigger fired if the report execution fails ?
How to retrieve the count of updated rows?
What is difference between cartesian join and cross join?
What is instant client oracle?
What happens if the update subquery returns multiple rows?
What are the advantages of oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
