We can create more unique key in a table but we can not create more then o

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 / prativa mishra

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

Answer Posted / prativa mishra

We can create more unique key in a table but we can not create more then one primary key in a table.At the time of primary key creation thr is a clusterd index created automatically and it sorts data physically. It helps in searching process which not possible in unique+notnull column

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is a cursor? : Sql dba

1002

What's the difference between inner join and left join?

983

how to create a new view in mysql? : Sql dba

923

Explian rowid, rownum?

991

What is pl sql commands?

1020

Can we insert in view in sql?

1036

What are keys in sql?

978

how to escape special characters in sql statements? : Sql dba

1015

How does cross join work?

917

What is auto increment?

972

Can you have more than one key in a database?

917

How do you use a while loop in pl sql?

991

What is a delimiter in sas?

1030

How do you write an index?

948

What is relationship? How many types of relationship are there?

1148