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

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 / sdp

7 Answers
15226 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / sdp

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

Is This Answer Correct ?

21 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Are pl sql variables case sensitive?

1053

What are the rules to be applied to nulls whilst doing comparisons?

1323

What is a temp table?

1030

Is sql dba a good career? : SQL DBA

995

Can we perform dml in function?

1071

What is before trigger?

1006

Is primary key clustered or nonclustered?

1021

Do we need to create index on primary key?

929

Explain the savepoint statement.

1102

What is the purpose of cursors in pl/sql?

1138

what is index? : Sql dba

1008

What is rank function in sql?

1030

What are the commands used in sql?

1081

How to select random rows from a table?

1081

What is having clause in sql?

969