what is the difference between primary key & foreign key?
- 57 Answers
- 122365 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / guest
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 ? | 155 Yes | 19 No |
Post New Answer View All Answers
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to save query output to a local file?
What is the difference between Delete, Truncate and Drop in Oracle?
How to create an oracle database?
What is the implicit cursor in oracle?
What is a system tablespace and when it is created?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is integrity and what is constraint??Explain with example
What is save point in oracle database?
What happens if the imported table already exists?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Can we create trigger on materialized view in oracle?
Point the difference between translate and replace?
What is the maximum number of triggers that can be applied to a single table?
Can we create database in oracle using command line ?
