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.
Loading...
Related Quiz
- How does DB2 handle invalid XML characters within tags?
- Which term refers to the process of ensuring continuous access to data in the event of a system failure?
- What is the primary purpose of data compression in DB2?
- What are some common file formats supported by the IMPORT utility in DB2?
- What actions can the Health Monitor take in response to identified issues?