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 / satya prasad n

The PRIMARY KEY cannot be null. you can insert ZERO into
that but should not be null. It will throw an error if you
try to inserts a NULL.

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the prerogatives?

627


List down the types of triggers in the db2 database?

600


What types of tables are there in the db2 database?

563


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

209


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

711






What is the reason behind not using select * in embedded sql programs?

617


Explain db2.

630


What is bind package and plan in db2?

604


What is the role of schema in the db2 database?

665


How to find schema of a table in db2?

578


List out the data types available.

712


What is the role of the data page in the db2 database?

595


Mention some fields that are a part of sqlca.

610


What does reorg do in db2?

585


What is the use of commit in db2?

640