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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bind in db2?

816


What is netezza database?

803


Is schema the same as database?

863


How does coalesce work?

785


What is db2 plan table?

841


How do you pull up a query which was previously saved in qmf?

939


What is page size in db2?

770


How does db2 sample database connect?

806


What is db2? Explain.

814


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

992


What is the use of db2?

832


How to resolve deadlock issue

19115


How do I add a column in db2?

824


What is cursor in dbms?

857


How can you find out the # of rows updated after an update statement?

886