Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 139047 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ansul singh
Primary key is unique key but Foreign key always refers to
primary key.
Primary key is the parent & Foreign key is the child.
Primary key is unique, Primary key is not null and
Foreign key is null, Foreign key reference as primary key
is another table.
Primary key will not allow "Null values" & "Duplication
values",
Foreign key will allow "Null values & "Duplicate values" &
it refers to a primary key is another table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the importance of .pll extension in oracle?
How to increment dates by 1 in oracle?
How to select an oracle system id (sid)?
Difference between the “verify” and “feedback” command?
What do you mean by a tablespace?
How to sort output in descending order in oracle?
What are the original export and import utilities?
How to convert character types to numeric types?
How do you tell what your machine name is and what is its IP address?
How to revoke create session privilege from a user in oracle?
What are a collation and state the different types of collation sensitivity?
What is the exact use of Collections?
List the parts of a database trigger.
Why packages are used in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
