what is difference between foreign key and reference key
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
List out the types of joins.
State and explain about oracle instance?
How to load data through external tables?
What is enter substitution variable in oracle?
please explain.. DB architecture ...
Are truncate and delete commands same? If so why?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to get execution statistics reports on query statements?
How index is implemented in oracle database?
why dont we assign not null constraint as table level constraint.
how to clone 9i Database on to 10g Database.
How to define a procedure inside another procedure?
How to enter a new row into a table interactively?
How to start your 10g xe server?
Where are the settings stored for each instance in oracle?