Primary key can be assigned to only 1 column in the table but this is not

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT
AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A
COLUMN ?
INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN.
WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE
ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS
NULL VALUES.

Question Posted / shwetalguglanicse

3 Answers
7092 Views
I also Faced
E-Mail Answers

Answer Posted / shwetalguglanicse

Primary key can be assigned to only 1 column in the table but
this is not with unique key
And UK allow duplicate value but PK does not .

Is This Answer Correct ?

2 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the roles of dba?

1070

How can you use check constraints for self referential integrity?

971

How to compare dates in oracle sql?

1106

What happens to the current transaction if the session is killed?

990

How to lock and unlock a user account in oracle?

1108

What is an oracle user account?

993

Is java required for oracle client?

1002

How to create a new view in oracle?

1078

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2265

What is sharded cluster?

1015

How to rebuild an index in oracle?

1028

What do you mean by merge in oracle?

996

What are the different oracle database objects?

1094

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

Â How to use an oracle sequence generator in a mapping?

1076