🎴 Flashcard Mode
Database Administration Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
In NPS, in the expression 'NULL = NULL' results in a value of 'true'
AnswerClick to flip back
A
NULL=NULL
💡 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.