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

What is materialized view in Oracle?

1112

What is columnar storage what is the advantage?

1119

how the indexes are stored in the Oracle Database?

2331

How to create a new view in oracle?

1125

Explain the difference between a procedure and a function?

1236

What are the differences between lov and list item?

1139

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2673

Point out the difference between user tables and data dictionary?

1032

What is raw datatype in oracle?

1205

In which language oracle has been developed?

1134

what are archived logs?

2258

What is where clause in oracle?

1075

What are the ansi data types supported in oracle?

987

How to define an oracle sub procedure?

1221

What are temporal data types in oracle?

1164