A table can hava 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 / radhika

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

Answer Posted / radhika

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

Is This Answer Correct ?

16 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we call stored procedure in function?

963

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1109

Write a sql query to find the names of employees that begin with ‘a’?

1015

What is a record in pl/sql?

1150

What is a table?

1021

How to select 10 records from a table?

1159

What is package in pl sql with an examples?

1038

Is pl sql useful?

997

What are stored procedures in mysql?

1019

What are literals in sql server?

1173

Is sql better than access?

1021

What is the difference between function and procedure in pl/sql?

1090

how many sql dml commands are supported by 'mysql'? : Sql dba

1125

how to add a new column to an existing table in mysql? : Sql dba

1073

What is before and after trigger?

963