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 a corelated subquerry?

1063

Explain about mirror activator disk mirroring?

957

What is a trigger in the db2 database?

1014

Which isolation level provides maximum concurrency?

1089

Is db2 a programming language?

983

What is difference between isnull and coalesce?

1006

What is syscat in db2?

950

What is buffer pool?

1028

What is the physical storage length of the data types date, time, and timestamp?

1039

What is a Foreign Key?

1036

What does db2 stand for?

958

What does db2 plan contain?

960

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

1030

How can we retrieve the total number of records in RPG & CLLE?

577

What happens in bind step in a db2 program?

913