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

Explain an integrity constrains?

1149

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1046

How to resolve name conflicts between variables and columns?

1031

How to write text literals in oracle?

1068

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2256

How to run the anonymous block again?

1132

How to import one table back from a dump file?

1025

Explain an extent?

1105

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1019

Differentiate between function and procedure in oracle.

1077

How to define an anonymous procedure with variables?

1160

Explain self joins in oracle?

1019

How do I uninstall oracle 11g?

1119

What is meant by an index?

1145

How to check database size in Oracle?

1191