what is the difference between primary key & foreign key?
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
Will you be able to store pictures in the database?explain.
How do I learn what codesets are available in oracle?
What are advantages of dateset in datastage?
Is there a function to split a string in plsql?
What is a private synonym?
what are the default admin accounts in Oracle 10g ?
What is the best way to do multi-row insert in oracle?
How to create an oracle database?
What do you mean by redo log file mirroring?
How does oracle handle read consistency?
Can multiple columns be used in group by in oracle?
What is meant by recursive hints in oracle?
What is an oracle transaction?
What are the logical operations?
Explain integrity constraints?