Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137192 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 database link?
What is set verify off in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
Explain the use of tables option in exp command.
What happens to the current transaction if the session is ended?
What is the use of oracle?
How many types of synonyms in Oracle?
What is a subquery in oracle?
What are the ansi data types supported in oracle?
How to view the tablespaces in the current database?
Explain a data segment?
Why is oracle used?
Does facebook use oracle?
What is tns service name?
How to increment dates by 1 in oracle?
