How does DB2 handle NULL values for columns defined with NOT NULL constraint?

  • It allows NULL values
  • It depends on the version of DB2
  • It rejects any attempt to insert NULL values
  • It replaces NULL with a default value
When a column is defined with a NOT NULL constraint, DB2 rejects any attempt to insert NULL values into that column. This ensures data integrity by enforcing the rule that the column must have a value for every row. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *