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 the four Oracle system processes that must always be up and running for the database to be useable?

1019

How to set up autotrace for a user account?

1059

Use of an integrity constraint is better to validate data. Explain

1043

Give the various rollback segment states.

1052

What privilege is needed for a user to delete rows from tables in another schema?

1070

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

What is ordinary table in oracle?

1159

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

What are the different types of modules in oracle forms?

1001

What are the differences between char and nchar in oracle?

1097

What are the different types of trigger and explain its various uses and functions?

1097

What is system tablespace?

1101

Why is oracle used?

944

Explain the types of exception?

1146

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

1230