1.you can assign UK + NN TO A COLUMN behave like PRIMARY KEY(PK) but (UK +

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 / adil khan

3 Answers
6925 Views
I also Faced
E-Mail Answers

Answer Posted / adil khan

1.you can assign UK + NN TO A COLUMN behave like PRIMARY KEY(PK)
but (UK + NN) can not make any relation with any other table.
where as PRIMARY KEY(PK) can make relation with others tables.

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between alert log file and tarce file ?

2095

Explain cascading triggers.

1011

What is query image?

921

What is a proxy object?

1007

Describe the types of sub query?

938

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4478

How to use group functions in the select clause using oracle?

1022

What are the various types of snapshots ?

970

Can we call procedure inside function in oracle?

1017

How to speed up webrick?

1004

Explain the difference between sql and oracle?

1022

What is the difference between a user and a schema in oracle?

981

What do database buffers contain?

956

How do I uninstall oracle client from windows?

960

How to create a new view in oracle?

1012