Multiple choice technology databases

Which function forces group functions to include null values?

  1. Group By

  2. NVL

  3. Order By

  4. Having
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

NVL replaces null values with a specified substitute before aggregation, forcing group functions like SUM or AVG to treat nulls as a concrete value. GROUP BY controls grouping, ORDER BY sorts results, and HAVING filters groups, none of which alter null handling within aggregates.

Keep practicing — related questions