Database Developer Question:

Download Job Interview Questions and Answers PDF

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.

Download Database Developer Interview Questions And Answers PDF

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