what is the difference between primary key & foreign key?
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 use of triggers in Java program? I mean where do we use triggers in Java programming?
What do you mean by merge in oracle and how can we merge two tables?
What is a read only transaction in oracle?
What privilege is needed for a user to query tables in another schema?
How to create a testing table in oracle?
How to export your own schema?
What is ordinary table in oracle?
What is Segment Advisor in Oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is bulk copy or bcp in oracle?
How to add a new column to an existing table in oracle?
What is transport network substrate (tns) in oracle?
Explain the use of analyse option in exp command.
Explain an integrity constrains?
What is the best way to do multi-row insert in oracle?