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?

Answer Posted / sangeetha

There cannot be null values in a Primary Key column.
It will result in error code.

Is This Answer Correct ?    26 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would the varchar column remarks defined?

635


How do I start db2 in windows?

565


Mention the downsides of page level lock.

709


What are packages in db2?

597


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1818






What is the maximum No of rows per page?

626


What is db2 stogroup?

675


How to resolve deadlock issue

17971


What are db2 tables?

647


How do I copy a table in db2?

573


How to retrieve rows from a db2 table in embedded sql?

730


What are bind parameters in db2?

613


How to find primary key of a table in db2?

613


Why do we use cursor?

599


Why do we need reorg in db2?

564