what is the difference between primary key & foreign key?
- 57 Answers
- 122060 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / hardik patel
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity.
| Is This Answer Correct ? | 65 Yes | 20 No |
Post New Answer View All Answers
How to rollback the current transaction in oracle?
How to retrieve data from an cursor to a record?
Explain rename?
How do I find my oracle client driver version?
How to run queries on external tables?
Explain what are the different type of segments?
How to list all tables in your schema?
Explain integrity constraints?
How to view existing locks on the database?
Explain the different normalization forms?
What is ceil and floor in oracle?
What is a nested table and how is it different from a normal table?
is there a tool to trace queries, like profiler for sql server?
What is the difference between substr & instr functions?
What is concurrency in oracle?
