Primary Key=Unique+Not Null+Sorting+Cluster Index So UNIQUE +NOT NULL !=

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

Question Posted / kuldeep singh

Answer Posted / kuldeep singh

Primary Key=Unique+Not Null+Sorting+Cluster Index
So
UNIQUE +NOT NULL != PRIMARY KEY
it cant refer someother table column

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are operators in oracle?

1100

How to create a table interactively?

1161

What is a subquery in oracle?

1163

Explain about integrity constraint?

1176

What do you understand by database schema and what does it hold?

1296

What is the difference between postgresql and oracle?

1101

How to sort output in descending order in oracle?

1100

What are advantages of dateset in datastage?

2305

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2340

How to bring a tablespace offline?

1112

How to execute a stored program unit?

1126

Can we save images in a database and if yes, how?

1108

candidate key is subset of super key but not vice-verse explain

2106

What is the difference between view and materialized view in Oracle?

1203

Is oracle an operator?

982