The ____ function can be used to include NULL values in a calculation.
A) AVG
B) SUM
C) NULL
D) NVL

Question

The ____ function can be used to include NULL values in a calculation.​
A) ​AVG
B) ​SUM
C) ​NULL
D) ​NVL

Quizplus · Accepted Answer

The NVL function (Oracle) or COALESCE function (SQL Server, PostgreSQL, MySQL) can be used to replace NULL values with a specified value. This is useful in calculations where the presence of NULL values could cause errors or incorrect results. By replacing NULL values with a specific value, such as zero, the calculation can proceed as intended.

The ____ Function Can Be Used to Include NULL Values