A primary key can have a NULL value. The error will be shown only when NO

Can a primary key have null values? If we try to insert a
null value in a primary key column, will it work or give an
error code?

Question Posted / guest

Answer Posted / guest

A primary key can have a NULL value. The error will be
shown only when NOT NULL is defined in the table creation.

Is This Answer Correct ?

10 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Name the various locking levels available?

1101

How to find the number of rows in db2 tables?

1073

what is db2 restart?

2165

How will you return the number of records in table?

944

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What is netezza database?

1032

What is nvl in db2?

1103

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2860

Mention data types used in db2 ?

1166

What is the maximum size of a char data type in db2?

1012

Can there be more than one cursor open for any program?

1173

What does db2 plan contain?

1031

How can you classify the locks in db2?

1093

Define predicate?

1140

List some fields from sqlca?

1061