Multiple choice technology databases

Which function can return a non-NULL value if passed a NULL argument?

  1. NULLIF

  2. LENGTH

  3. CONCAT

  4. INSTR

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

CONCAT ignores NULL arguments and returns the non-NULL value, making it the correct choice. NULLIF returns NULL when its two arguments are equal, LENGTH returns NULL when given NULL, and INSTR also returns NULL with NULL inputs.