Primary Key cannot have NULL values in it wherein an UNIQUE index can hav

What is the difference between primary key & unique index ?

Question Posted / shankar

Answer Posted / shankar

Primary Key cannot have NULL values in it wherein an
UNIQUE index can have one NULL value in it.

Is This Answer Correct ?

37 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What do you mean by cursor?

988

What are the contents of a dclmgen?

1122

What is performance tuning db2?

1058

Explain correlated sub-queries.

1025

What is the advantage in De-normalizing tables in DB2?

1168

When the like statement is used?

1222

What's The Percentage Free Space ?

1224

Explain various types of locks in db2?

1140

What is the purpose of using commit?

1095

What are db2 tables?

1121

How do you pull up a query which was previously saved in qmf?

1148

How to rename a table in DB2 ?

1086

How to check last update on table in db2?

1055

How to find the number of rows in a db2 table?

1116

Explain what are the various isolation levels possible?

1041