The ____({value},{replace})function replaces NULL values in expressions,avoiding SQL errors.
A) NVALUE
B) NVAL
C) NVL
D) NIL

Question

Quizplus · Accepted Answer

The NVL function is used to replace NULL values in expressions with a specified value. It takes two parameters – the first one being the expression that may contain NULL, and the second one being the replacement value in case the expression is NULL. The NVL function is commonly used in SQL to avoid errors that may arise due to NULL values. The other options (NVALUE, NVAL, and NIL) are not valid SQL functions.

The ____({Value},{replace})function Replaces NULL Values in Expressions,avoiding SQL Errors