Primary key creates Clustered Indexes. Clustered indexes physically sort th

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS
NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY
WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT
ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT
DUPLICATE VALUES?
SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND
PRIMARY KEY??????

Question Posted / upendra

8 Answers
10168 Views
rsystems, I also Faced
E-Mail Answers

Answer Posted / upendra

Primary key creates Clustered Indexes. Clustered indexes physically sort the data.
Unique can have only Non-clustered indexes, where data are not physically sorted.

Is This Answer Correct ?

14 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does left join work in sql?

938

How many clustered indexes can be created on a table?

1022

What is the difference between clustered and non-clustered index in sql?

953

What are the different types of joins in sql?

1648

What is the non-clustered index in sql?

1006

What is union, minus and interact commands?

1212

How to display Row Number with Records in Oracle SQL Plus?

990

What is duration in sql profiler trace?

1018

What is pivot table in sql?

1013

What is the difference between partition and index?

919

What is dml with example?

1011

What are the advantages of pl sql over sql?

960

Can you rollback after commit?

930

what is self-join? : Sql dba

1050

What are the operators used in select statements?

998