Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between foreign key and reference key
- 3 Answers
- 42290 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
What is an oracle function?
why dont we assign not null constraint as table level constraint.
What is the difference between alert log file and tarce file ?
What is procedure overloading in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to assign query results to variables?
What are triggers in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
State and explain the different types of data models?
What is a synonym? What are its various types?
How to convert characters to numbers in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
what is IDE,DMV in sql server?
How to start a new transaction in oracle?
What is hot backup and logical backup?
