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

What is the purpose of a sql?

977

Are subqueries faster than joins?

1023

what are properties of a transaction? : Sql dba

1094

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

How do I sort a table in sql?

1051

How can you load multi line records? : aql loader

1078

What is difference between pls_integer and integer?

968

what are the security recommendations while using mysql? : Sql dba

1123

Can I create table without primary key?

1003

How do I find duplicates in sql?

935

Is sql microsoft?

1059

How to make a copy values from one column to another in sql?

1038

Is sql between inclusive?

1137

What's the difference between inner join and left join?

1002

How delete all records from table in sql?

981