Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137528 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohammadazam
A primary key is an combination of attributes that uniquely
identifies each row in a relation. A primary key is
designated by underlining the attribute name. The primary
key of an entity set allows us to distinguish among the
various entities of the set.
A foreign key is an attribute in a relation of database
that serves as the primary key of another relation in the
same database.
| Is This Answer Correct ? | 17 Yes | 6 No |
Answer / khan
i dont know
i just read above
and all answer seems to b same and correct
i am confused
| Is This Answer Correct ? | 30 Yes | 21 No |
Answer / dimna
primay key uniquely identifies records in relation.
in a table only one primary key.But may have more than one
foreign key.
| Is This Answer Correct ? | 17 Yes | 9 No |
Answer / ibrahim
primay key uniquely identifies records in relation.
in a table only one primary key.But may have more than one
foreign key.
| Is This Answer Correct ? | 14 Yes | 7 No |
Answer / navane
Primary key is a keyword.
It should not have null value and duplicate value.
We can have only one primary key in a table and the value
should be unique.
Foreign key is a keyword.
It can have null value and duplicate value.
We can have more than one foreign key for a table and this
froeign key table references the primary key table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ilakarthi
primary key is available in foreign key but not available in the foreign key for a primary key
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vaziuddin shaik
PRIMARY KEY
-------------
Primary key is a column in a table which is having unique
values......and it does not contain null values and
duplicate values...........
FOREIGN KEY
-------------
Foreign key is a column in a table which act as reference to
another table.....and it may contain null and duplicate
values.....(or)it may not contain null and duplicate
values...........
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sairam
primary key is an individual key
foreign key depends in primary key
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / himabindu
primary key is unique.it does not allow null&duplicate
values.it is individual.
foreign key always refers primary key.it is
independent
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rathika
only one primary key on the table.
more than one foreign key on a table
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the usage of synonyms?
How to use null as conditions in oracle?
What is the difference between I and G in Oracle?
Why we use bulk collect in oracle?
What is the difference between substr & instr functions?
What is SAVE POINT ?
What is Database Trigger ?
Explain the difference between replace() and translate() functions in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
How to display the hierarchy of employee and managers without using connect by prior.
How to grant create session privilege to a user in oracle?
Oracle General 
