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

How can deadlocks be resolved?

542


What is the default page size of buffer pools?

648


What is runstats db2?

585


What is db2 purescale?

549


What are db2 tables?

648






How to fetch the last row from the table in SQL (db2)?

1037


Define sqlca.

649


Give a brief description of db2 isolation levels?

601


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7512


What happens in bind step in a db2 program?

569


What is db2 bind process?

757


Differentiate between cs and rr isolation levels? Where do you specify them?

585


What type of database is db2?

523


Name the various locking levels available?

634


What is db2 connect?

609