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

What is the connection string to connect to the DB2 Database ?

1171

What is dbrm?

1177

How to check table size in db2 sap?

1093

Which command is used to connect to a database in DB2 ? Give the Syntax.

1146

What is db2 and what is the use of db2 optimizer?

1108

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1137

What is the function of logging in the db2 database?

1172

What is the picture clause of null indicator variable?

1178

What is phantom read in db2?

1220

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

1048

What are host variables in db2?

1120

Mention the downsides of page level lock.

1212

How does cobol compile db2 program?

1124

Explain about rct.

1129

How do you find the maximum value in a column in db2?

1151