What is the difference between the Primary and Foreign key?
Answer Posted / dhirendra
Primary Key: This is a constraint which is always unique &
not null.
Foreign Key: This is a constraint which is just opposite to
Primary key. It can be not Null & can accept duplicate value
as well. Foreign key points to same table's primary key or
another table's primary key to make a relationship.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Define sql delete statement.
How do you write a subquery?
What is compilation error in pl sql?
What are hotfixes and patches?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Show the two pl/sql cursor exceptions.
Can a procedure in a package be overloaded?
Can delete statement be rollbacked?
what is data control language? : Sql dba
What is clustered index in sql?
What is the use of pl/sql table?
What are the two types of cursors in pl sql?
How many types of triggers exist in pl/sql?
Can a varchar be a primary key?
What is trigger with example?