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
7152 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

List the various oracle database objects?

993

What is BBED in Oracle?

1086

When do you get a .pll extension in oracle? Explain its importance

983

What is meant by an index?

1054

What is the maximum limit on the number of columns in a table?

1002

What is null value in oracle?

1032

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1982

How to end the current transaction in oracle?

961

What happens to indexes if you drop a table?

1107

How to rename a column in an existing table?

971

Explain joins in oracle?

977

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

2260

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2194

What are the different types of database objects?

990

What are the advantages of oracle 12c?

1118