Multiple choice

NVL ( ) function

  1. substitutes NULL value for a given value in a query result

  2. substitutes NULL value with a specified value in a query result

  3. substitutes NULL value with '00' in a query result

  4. substitutes space for NULL value in a query result

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

The NVL function in Oracle replaces a NULL value with a specified expression or value.