what is the difference between primary key & foreign key?
- 57 Answers
- 122461 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is oracle sid?
How to use group functions in the select clause using oracle?
Can select statements be used on views in oracle?
How to update values in a table in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is the difference between substr & instr functions?
How to view existing locks on the database?
How to create an oracle testing table?
In oracle there is column command, how will you explain that?
Explain the difference between sap and oracle?
State the difference between a primary key and foreign key?
what happened to the global index when I truncate the data in one of the partition?
What is snapshot is too old? Give and example for better understand.
Can we write dml statement in function in oracle?
Explain self joins in oracle?
