what is the difference between primary key & foreign key?
- 57 Answers
- 122640 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vasavi
primary key does not allow duplicate and null values
primary is unquie.
foreign key allows null values it refers primary key.
foreign key allows duplicate values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amuthan
primary key is the parent and foreign is the child.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anjanareddy
i cleared this question simple.
TAKE A LOOK
primary key:-It doesn't allow NULL values and duplicate values
it is a unique one.
Foreign key:- It allows NULL and duplicate values
It always give reference to primary key of another table
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / zacharia ismail
primary key: primary creates a clustered index on the
column and it doesn't allow null values.
foreign key: A foreign key (FK) is a column or combination
of columns used to establish and enforce a link between the
data in two tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / pravin
The primary key of a relational table uniquely identifies
each record in the table. It can either be a normal
attribute that is guaranteed to be unique (such as Social
Security Number in a table with no more than one record per
person) or it can be generated by the DBMS (such as a
globally unique identifier, or GUID, in Microsoft SQL
Server). Primary keys may consist of a single attribute or
multiple attributes in combination.
Examples:
Imagine we have a STUDENTS table that contains a record for
each student at a university. The student's unique student
ID number would be a good choice for a primary key in the
STUDENTS table. The student's first and last name would not
be a good choice, as there is always the chance that more
than one student might have the same name.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / suraj menon
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raffi.shaik
Primary key is unique
primary key is not NULL and
foreign key is NULL
foreign key reference as Primary key in another table
Primary key is unique key but foreign key always refers to
primary key
primary key is used to identify a row and it does not allow
null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the definition of referential integrity.
In the context of relational databases, a foreign key is a
referential constraint between two tables.[1] The foreign
key identifies a column or a set of columns in one
(referencing) table that refers to a column or set of
columns in another (referenced) table. The columns in the
referencing table must form a primary key or unique key.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / baburao
primary key is a key which can define unique values
where as foreign key refers to a parent table and depends
on primary key
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / g. rajamani
Primary key is a key, that is a not null or unique key. But
foriegn key is null, that is refere to the primary key.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a trigger oracle?
What is the use of file param in imp command?
candidate key is subset of super key but not vice-verse explain
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to connect to the server with user account: sys?
What are steps required to ENTER DATA INTO DWH?
What are the differences between date and timestamp in oracle?
How to create a table index in oracle?
How to retrieve the count of updated rows?
What is ADDM Advisor in Oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
Oracle General 
