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

Which component is responsible for db2 startup and shutdown?

813


Is db2 relational database?

741


What is database alias db2?

859


What is the role of union all and union

870


What is concurrency?

914


How to check table size in db2 sap?

786


Why db2 is called db2?

774


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

833


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

941


What is db2 catalog database?

795


What is the maximum number of columns in a db2 table?

993


can all users have the privilage to use the sql statement select * (dml)?

856


What kind of database is db2?

783


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

857


Before you give the explain statement, what are the prerogatives?

782