Multiple choice technology databases

I am working on manager number field on some table. which is correct usage of nvl function usage....?

  1. nvl(mgrno,0)

  2. nvl(mgrno,'none')

  3. nvl('mgrno',0)

  4. nvl(mgrno,'0')
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The NVL function in SQL requires both parameters to have compatible data types. Since mgrno is a numeric field, the replacement value must also be numeric. NVL(mgrno, 0) correctly substitutes NULL values with 0, while options with '0' or 'none' are strings that would cause type mismatch errors.

Keep practicing — related questions