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

List out the three types of page locks that can be held.

681


What is bind and rebind in db2?

644


What is a Foreign Key?

650


What is difference between alias and synonym in db2?

635


Mention the different locking levels that are available in db2.

635






Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6808


How to find the maximum value in a column in the db2 database?

601


How to find the number of rows in db2 tables?

607


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

711


How do you eliminate duplicate values in db2?

677


What are union and union all?

535


How would you find out the total number of rows in a db2 table?

572


What is the use of db2?

581


What is sqlca’s maximum length?

664


List out the buffer pools in db2

622