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

How does rowid help in running a query faster?

1371

What is null in pl/sql?

1024

How can you load microsoft excel data into oracle? : aql loader

1130

what is the command line end user interface - mysql? : Sql dba

928

What are the advantages of indexing?

929

Can we use commit inside a trigger?

1030

Enlist some predefined exceptions?

1004

What is scalar function?

1002

How to pipe multiline string to isql?

961

What type of database is cloud sql?

1046

How to Declare Fixed Length String Value In PL SQL

1105

How do I know if I have sql express or standard?

980

Why do we use sql constraints?

1124

What are the steps for performance tuning.

1273

What are all different types of collation sensitivity?

978