what is the difference between primary key & foreign key?
- 57 Answers
- 122468 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / deepa
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 ? | 22 Yes | 7 No |
Post New Answer View All Answers
What are the different types of modules in oracle forms?
what is the difference between substr and instr function in oracle?
Please explain drop constraint oracle?
What happens if the imported table already exists?
How to define a procedure inside another procedure?
How can you use check constraints for self referential integrity?
What is an oracle function?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How do you tell what your machine name is and what is its IP address?
How to synchronize 2 schema's objects?
Explain the difference between a procedure and a function?
What are the limitations oracle database 10g xe?
What is a table index?
What happens to the current transaction if the session is ended?
What is the difference between post-database commit and post-form commit?
