if unique then it can have null but if column has primary then it cannot

What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?

Question Posted / kiran

Answer Posted / kiran

if unique then it can have null

but if column has primary then it cannot have null values
and duplicate values

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to do a full database export?

856

How to create a stored function in oracle?

832

What is analyze command used for?

805

In which language oracle has been developed?

851

Explain a data segment?

845

What is different types of joins?

771

What is bulk collect in oracle?

761

How to concatenate two text values in oracle?

835

What is bind variable in oracle 11g?

801

Describe varray?

838

Differentiate between function and procedure in oracle.

779

How does the on-delete-cascade statement work?

849

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1878

How to manage transaction isolation level?

758

What is the difference between $oracle_base and $oracle_home?

807