what is the difference between primary key & foreign key?
Answer Posted / suraj menon
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to pass parameters to procedures?
What is a trigger and what are its types in oracle?
What privilege is needed for a user to create views in oracle?
What types of joins are used in writing subqueries?
What is primefaces used for?
Explain about integrity constraint?
What is oracle instant client?
What is parameterized cursor in oracle?
What happens to the data files if a tablespace is dropped?
How to start an oracle instance?
Can multiple cursors being opened at the same time?
How to define an anonymous block?
Explain the different normalization forms?
Use of an integrity constraint is better to validate data. Explain
how to handle exceptions in post production