what is the difference between primary key & foreign key?
- 57 Answers
- 122251 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / navane
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 ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between substr & instr functions?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is archive log in Oracle?
What is a sub query? Describe its types?
What are the components of logical database structure in oracle database?
How to call a stored function with parameters?
how to make an oracle object
How to export data with a field delimiter?
What is the database name in oracle?
What is a proxy class?
Why do we use coalesce function in oracle?
What is the difference between post-database commit and post-form commit?
Please explain oracle left join with an example?
Explain the difference between sap and oracle?
How to write a query with a left outer join in oracle?
