what is the difference between unique and primary key

Categories >> Software >> Databases >> Database Management
Suggest New Category

Question Posted / guest

5 Answers
6101 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between unique and primary key..

Answer / ravi kanth

Primary key is the combination of unique and not null.But
unique key accepts null values also.

Is This Answer Correct ?

6 Yes

1 No

what is the difference between unique and primary key..

Answer / suresh kumar somayajula

Unique Key allows NULL value and a table can have more than
one UNIQUE KEY Constraint.

Primary Key is the combination of UNIQUE+NOT NULL,means it
won't allow NULL Values and a table can have only one
Primary Key.But a table can have Composite Primary Key.

Thank you,
Suresh

Is This Answer Correct ?

4 Yes

0 No

what is the difference between unique and primary key..

Answer / priyanka

Both are uniqe identification keys but Primary key should
not be null but uniqe key should.

Is This Answer Correct ?

1 Yes

1 No

what is the difference between unique and primary key..

Answer / divyarao

primary key accepts only values which has no duplication ,and does not accept null values . for a a table there should be only one primary key constraint.
whereas in unique key ,it accepts null values .here also there should not be any duplication ,a table may have more than one unique key constarint

Is This Answer Correct ?

0 Yes

0 No

what is the difference between unique and primary key..

Answer / vinod

uniqe key allow one null value only but primary key cannot
allow any null value

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Database Management Interview Questions

What is cold backup (in case of oracle)?