Unique-Duplicates not allowed Nulls allowed Not null-NUlls not all

what are the advantages of primary key over unique+notnull

Question Posted / charumathi

Answer Posted / charumathi

Unique-Duplicates not allowed
Nulls allowed
Not null-NUlls not allowed
Primary key-No Duplicates
No Nulls
A Foriegn key can refer to the primary key.

Is This Answer Correct ?

4 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Is sql considered coding?

1043

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1065

Is sql sequential or random?

1031

Which is the correct statement about truncate and delete?

1110

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

1031

Can unique keys be null?

908

What do you mean by table in sql?

988

Is sql better than excel?

1152

How many functions are there in sql?

1017

Why are cursors used?

1122

how many groups of data types? : Sql dba

1026

Is inner join faster than left join?

1190

What is embedded sql in db2?

1017

How to disable a trigger name update_salary?

1266

what is a composite primary key ? : Sql dba

1050