what is mean by prmary key and foreign key and how can we
diffrentiate that?
Please answer me.
Advance thanks.
- 9 Answers
- 15066 Views
- BPO, Excel, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravi singh
Primary Keys: Primary keys are the identifier and applied
on the table in the form of constraints. Primary key
provides uniqueness in the data.
Foreign Key: Foreign Keys are the relationship and applied
on the table in the form of constraints. Foreign key in a
table is a primary key of another table and use to make
relationship between two tables.
| Is This Answer Correct ? | 59 Yes | 3 No |
Answer / cm
example :
primary key table: emp ( ENO, ename, address)
here eno is primary key
foreign key: table hari( ENO, phone, salary)
here same eno from hari table is used to get the values
from emp.
| Is This Answer Correct ? | 32 Yes | 1 No |
Answer / sandeep.n
primary key means to provide the information that the
colomn belongs to the same table, where as the forigen key
means to get the data from other table.
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / ysailajasantosh
Primary key means a unique key which is constant.
A foreign key (FK) is a column or combination of columns
that is used to establish and enforce a link between the
data in two tables. You can create a foreign key by
defining a FOREIGN KEY constraint when you create or modify
a table.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / harish
LET ME TELL IN SINGLE SENTENCE!!! :)
"ALL FOREIGN KEYS ARE PRIMARY KEYS BUT NOT VICE-VERSA"
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / ritesh singhq
primary key is a complete date for all the member and
subject like and employee and all the data like
sale : note book pen pencil eraser
foreign key is a complete data of particular 1 thing like
note book : company name , numn of note book , creation
date etc
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / nimmi
PRIMARY KEY : IS THE UNIQUE KEY OF A SINGLE TABLE THAT IS
THE UNIQUE IDENTIFICATION OF THE SAME TABLE.
FOREIGN KEY: MEANS A UNIQUE KEY IDENTIFICATION COMMON TO TWO
TABLES .
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / b.jaganathan
PRIMARY KEY: the key which is used in the database table
for an identification is said to be a "PRIMARY KEY"....
FOREIGN KEY: the key which is used in the another database
table is said to be a foreign key, for the specified data
table........
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / dheeban02
primary key is used as unique key and foreign key is referred
with foreign key
| Is This Answer Correct ? | 3 Yes | 3 No |
how to we delete a row using varray
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What is the function of Redo Log ?
Is it possible to enter only time value into a column of a table in sql?
What is meant by an index?
How to create a new table in oracle?
How to assign a table row to a record variable?
What is a Database instance ? Explain?
master table and child table performances and comparisons in Oracle ?
How to use "out" parameter properly?
How to update a table row with a record?
How to display the hierarchy of employee and managers without using connect by prior.
Oracle General 
