Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137529 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
Explain about integrity constraint?
What is partitioned table in Oracle?
How to execute the package in oracle?
What is a snapshot in oracle database?
In what script is snap$ created? In what script is the scott/tiger schema created?
How can windows applications connect to oracle servers?
What are a cluster and non-cluster index?
What is a cursor and what are the steps need to be taken?
How much memory your 10g xe server is using?
Does oracle charge for java?
How to resolve the ORA-39133 error in Oracle?
Explain a data segment?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to handle a single quote in oracle sql?
How to create a new table in oracle?
