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
List out the three types of page locks that can be held.
What is bind and rebind in db2?
What is a Foreign Key?
What is difference between alias and synonym in db2?
Mention the different locking levels that are available in db2.
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?
How to find the maximum value in a column in the db2 database?
How to find the number of rows in db2 tables?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How do you eliminate duplicate values in db2?
What are union and union all?
How would you find out the total number of rows in a db2 table?
What is the use of db2?
What is sqlca’s maximum length?
List out the buffer pools in db2