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
10169 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 is rank function in sql?

957

How to download oracle sql developer?

1054

What is the source code of a program?

1001

What is a database? Explain

1049

explain normalization concept? : Sql dba

996

What are the various levels of constraints?

1058

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1040

what is online transaction processing (oltp)? : Sql dba

932

how to use in conditions? : Sql dba

957

Why is nosql good?

974

Enlist some predefined exceptions?

991

What is a trigger in sql?

1156

Define overloaded procedure?

1011

What will you get by the cursor attribute sql%notfound?

1011

Explain the steps needed to create the scheduled job?

965