the above answer is wrong ...we can use foreign key for unique key also..

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 / shahid

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

Answer Posted / shahid

the above answer is wrong ...we can use foreign key for
unique key also...

Is This Answer Correct ?

8 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are crud methods?

1081

What is the use of nvl function?

1239

What does where 1/2 mean in sql?

1140

How do I add a primary key to a table?

1079

what is transaction? : Sql dba

1057

What are the most important characteristics of pl/sql?

1224

Mention what are different methods to trace the pl/sql code?

1292

What is varray in pl sql?

1120

How do I upgrade sql?

1048

How are sql commands classified?

1141

What is varchar used for?

1134

Explain the advantages and disadvantages of stored procedure?

1198

what are string data types? : Sql dba

1090

How can I change database name in sql?

1155

Why is stored procedure faster than query?

1017