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

1002

Explain the commit statement.

1138

What language is oracle sql developer?

985

How would you pass hints to the sql processor?

967

what is a database lock ? : Sql dba

1151

What do you understand by case manipulation functions?

1009

Explain the uses of database trigger.

1097

What are string functions in sql?

1219

List the various privileges that a user can grant to another user?

1032

How many tables can you join in sql?

942

Is ms sql is free?

1007

What are stored procedures used for?

986

Explain the select statement in sql?

1094

How does index help in query performance?

1013

How can triggers be used for the table auditing?

1048