Database Developer Question:

Tell us how to Test for NULL Values?

Database Developer Interview Question
Database Developer Interview Question

Answer:

A field with a NULL value is a field with no value. NULL value cannot be compared with other NULL values. Hence, It is not possible to test for NULL values with comparison operators, such as =, <, or <>. For this, we have to use the IS NULL and IS NOT NULL operators.


Previous QuestionNext Question
Tell me what are the advantages of Views?Please explain what is a NULL value?