Multiple choice technology databases

SELECT NULLIF('testing','testing') FROM DUAL ;

  1. testing

  2. True

  3. null

  4. error

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

NULLIF returns NULL when both arguments are equal. Since both strings are 'testing', they match, so the function returns NULL. The function is designed to prevent errors by converting matching values to NULL.