Multiple choice technology databases

In NPS, in the expression 'NULL = NULL' results in a value of 'true'

  1. 0

  2. NULL=NULL

  3. 1

  4. 2
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Netezza Performance Server (NPS), comparing NULL to NULL using the equality operator (=) does not evaluate to true or false. Instead, any direct comparison with NULL results in NULL (or 'NULL=NULL' as represented in this context), because NULL represents an unknown value.

Keep practicing — related questions