Multiple choice technology databases

What is the result if two NULL values are compared to each other?

  1. TRUE

  2. FALSE

  3. Undefined

  4. NULL
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In SQL, NULL represents an unknown value. When two NULL values are compared using operators like =, <>, >, <, etc., the result is NULL (unknown), not TRUE or FALSE. This is because NULL is not a value but a marker for missing information, so comparing two unknowns yields an unknown result.

Keep practicing — related questions