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
Please explain joins in oracle?
How to best split csv strings in oracle 9i?
How to define an anonymous procedure with variables?
Is oracle a relational database?
What is data file?
What is Segment Advisor in Oracle?
How to get execution statistics reports on query statements?
Explain cascading triggers.
How to rename a column in an existing table?
How will you write a query to get a 5th rank student from a table student_report?
How to convert characters to dates in oracle?
What is the difference between $oracle_base and $oracle_home?
What is dual table oracle?
What is tns entry?
What is ordinary table in oracle?