what is the difference between primary key & foreign key?
- 57 Answers
- 122064 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
What is the difference between count (*), count (expression), count (distinct expression)?
How to assign query results to variables?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What are set operators?
What are the different pseudo commands? Explain in general?
What is a select query statement in oracle?
What is Data Dictionary Cache in Oracle?
How to drop a tablespace?
What is bulk copy or bcp in oracle?
What is oracle server autotrace in oracle?
How to use select statement to count the number of rows in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is an oracle data file?
How to define an anonymous block?
What is the difference between substr and instr?
