Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 139052 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / abhishek ranjan
The main diference between primary key and the foreign key is that the primary key is a column or a set of columns that can be used to uniquely identify a row in a table while the foreign key is a column or a set of columns that refer to a primary key or a candidate key of another table. Foreign key mainly provides a method to link information in several tables. Another difference is that a table can have a single primary key, but it can have multiple foreign keys that can reference different tables.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to delete a user account in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How many types of auditing in Oracle?
How to invoke the original export import utilities?
What is the difference between a user and a schema in oracle?
What are the general rules on data consistency?
How to open and close an explicit cursor in oracle?
How to define an anonymous procedure without variables?
How can you use check constraints for self referential integrity?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is truncate oracle?
Is oracle an operator?
Can group functions be used in the order by clause in oracle?
How a database is related to tablespaces?
How to empty your oracle recycle bin?
