1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the difference between UNIQUE CONSTRAINT and
PRIMARY KEY?

1. There is no difference.
2. A PRIMARY KEY cannot be declared on multiple columns.
3. A UNIQUE CONSTRAINT cannot be declared on multiple
columns.
4. A table can have multiple PRIMARY KEYS but only one
UNIQUE CONSTRAINT.
5. A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.

Question Posted / suresh

Answers were Sorted based on User's Feedback



What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no differen..

Answer / sdp

A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.

Is This Answer Correct ?    21 Yes 1 No

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no differen..

Answer / radhika

A table can hava multiple Unique constraints but only one
primary key.

Is This Answer Correct ?    16 Yes 1 No

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no differen..

Answer / rajesh.m

There is no difference.
The One & only Difference is a UNIQUE would allow Null
Values where as The Primary Key Not.

Is This Answer Correct ?    15 Yes 2 No

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no differen..

Answer / andsens

Fields in UNIQUE CONSTRAINTs can be NULL. They cannot with PRIMARY KEYs.
You can define more than one UNIQUE KEY in a table.
Because of this, the behaviour of UNIQUE CONSTRAINTs is very different from PRIMARY KEY constraints. As long as one of the fields in a UNIQUE CONSTRAINT is NULL the constraint itself does not apply and you can set the other fields to whatever you want without getting an error.

Is This Answer Correct ?    7 Yes 0 No

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no differen..

Answer / sunitha

yes, i agree with Rajesh ,primary key constraint doesn't allow null values but unique constraint allows null values.this is the main difference .

Is This Answer Correct ?    0 Yes 0 No

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no differen..

Answer / vikneswaran

1) primary key don't allow null values but unique const
allow null values
2)we can declare primary key as multiple column. but table
should have one primary key
3)we can declare unique as multiple column. but table should
have one unique key
4) and 5)

in table we can create multiple column of primary key and
multiple column of unique. but only the restriction is in
table should have one primary key and one unique key .. if
it is neccessary.

Is This Answer Correct ?    1 Yes 2 No

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no differen..

Answer / chandrasekar.ramasamy

A table can have compite primarykey but only one unique
constraint

Is This Answer Correct ?    0 Yes 15 No

Post New Answer

More SQL PLSQL Interview Questions

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

What are the differences between in and exists clause?

0 Answers  

What is denormalization in a database?

0 Answers  

when is the use of update_statistics command? : Sql dba

0 Answers  

What is Temp Table and type of temp table?

1 Answers   HP, SLK,




What are properties of the transaction?

0 Answers  

How do I run a pl sql program?

0 Answers  

what is sql.

6 Answers   Ericsson, Hewitt,

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

Is and as keyword in pl sql?

0 Answers  

Where is all the data on the internet stored?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories