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
10525 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

Why do we need cursor in pl sql?

1138

how to run 'mysql' commands from a batch file? : Sql dba

1120

discuss about myisam index statistics collection. : Sql dba

953

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1033

how many ways to get the current time? : Sql dba

1009

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1162

Can you load data into multiple tables at once? : aql loader

1068

How to Declare Fixed Length String Value In PL SQL

1158

How do you sort in sql?

1030

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3571

How long it takes to learn pl sql?

1014

Is it possible to read/write files to-and-from PL/SQL?

1103

What is pivot in sql?

918

What are sql queries used for?

1028

Why is theta join required?

1147