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

3 Answers
7196 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to view existing locks on the database?

1005

How to lock and unlock a user account in oracle?

1039

how to handle exceptions in post production

1369

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

981

What is background process in Oracle?

1058

can u plz provide me oca sql dumps please i need them

1908

Explain about integrity constraint?

1088

Explain enable novalidate constraint.

1044

What is a sub query? Describe its types?

970

What is integrity and what is constraint??Explain with example

2223

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5345

Can we store pictures in the database and if so, how it can be done?

992

what happened to the global index when I truncate the data in one of the partition?

1971

Can you have more than one content canvas view attached with a window ?

2274

What are the built-in functions used for sending Parameters to forms ?

3325