NO, UNIQUE +NOT NULL != PRIMARY KEY it cant refer someother table column

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

Question Posted / murugananthan

7 Answers
10475 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / murugananthan

NO, UNIQUE +NOT NULL != PRIMARY KEY
it cant refer someother table column

Is This Answer Correct ?

12 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of oracle?

981

Explain the characteristics of oracle dba?

1067

Is oracle a programming language?

935

How can I combine multiple rows into a comma-delimited list in oracle?

999

How to display row numbers with the records?

1024

What is the difference between primary key and unique key and foreign key in oracle?

918

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1934

What is save point in oracle database?

1239

What is BBED in Oracle?

1089

What is the usage of synonyms?

1060

In the oracle version 9.3.0.5.0, what does each number shows?

1224

What do you mean by a deadlock?

1008

Why do you create or replace procedures rather that drop and recreate.

946

What is an oracle user account?

929

How to use select statement to count the number of rows in oracle?

986