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 is the difference between truncate & delete command?

1120

Can you tell me how to add new column in existing views?how?How is possible?

1368

State all possible different index configurations a table can possibly have?

944

What is an index associated with a constraint?

973

How to define a record variable to store a table row?

1001

What happens if you use a wrong connect identifier?

975

What are temporal data types in oracle?

1063

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

2259

Explain the difference between replace() and translate() functions in oracle?

973

How to insert a new row into a table in oracle?

1087

What is the purpose of save points in oracle database?

1002

What is a snapshot log?

948

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1935

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

1025

Explain the use of full option in exp command.

1052