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 collation? : Sql dba

1077

Name the different types of indexes in sql and define them.

1069

what is a primary key? : Sql dba

981

What is a variable in sql?

948

What do you think about pl/sql?

943

How does an execution block start and end in pl sql?

899

What is information schema in sql?

1012

What does pl sql stand for?

1062

What does over partition by mean in sql?

919

what is a cursor? : Sql dba

972

What is a parameter query?

1017

What is the difference between an inner and outer join?

957

what are wild cards used in database for pattern matching ? : Sql dba

1075

Define a temp table?

961

What are the different sql commands?

1000