yes it is equivalent as primary key is nothing but unique and not null.

If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?

Question Posted / bhakti

Answer Posted / bhakti

yes it is equivalent as primary key is nothing but unique
and not null.

Is This Answer Correct ?

16 Yes

6 No

Please Help Members By Posting Answers For Below Questions

When do I need to use a semicolon vs a slash in oracle sql?

1042

How to create an oracle testing table?

1021

What are the extensions used by oracle reports?

1006

Explain user account with reference to oracle.

941

Why do we need integrity constraints in a database?

988

Can we call procedure inside function in oracle?

1039

What is a nested table and how is it different from a normal table?

1003

What is literal?

964

What are group functions in oracle?

992

What is procedure overloading in oracle?

1007

List the various oracle database objects?

1010

What is sequence?

1024

How to sort output in descending order in oracle?

999

Can we write insert statement in function in oracle?

1048

How to load data through external tables?

1088