Multiple choice technology databases

Choose the functions that can be used with NULL values

  1. NVL

  2. NULLIF

  3. DECODE

  4. COALESCE
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

NVL, NULLIF, and COALESCE are standard SQL functions designed specifically to handle NULL values. While DECODE can handle NULLs in its logic, it is primarily a conditional transformation function rather than a dedicated NULL-handling function like the others.

Keep practicing — related questions