what is the difference between primary key & foreign key?
- 57 Answers
- 122643 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / shaik gouse peer
Basic difference betweeen Primary key and foreign key is :
Primary key will not allow "Null values" and "Duplicate
values"
Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.
| Is This Answer Correct ? | 130 Yes | 25 No |
Post New Answer View All Answers
How to increment dates by 1 in oracle?
What is recovery manager in Oracle?
What happens to the indexes if a table is recovered?
Does facebook use oracle?
How do I find my oracle client driver version?
Explain the use of control file?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Why does oracle 9i treat an empty string as null?
Why do we use coalesce function in oracle?
How to drop an index?
How to create a single index for multiple columns?
What is difference between sid and service name in oracle?
How to loop through a cursor variable?
What is an external table?
What is oracle in java?
