Multiple choice technology platforms and products

Group functions include nulls in calculations

  1. True

  2. False

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

Oracle group functions (SUM, AVG, COUNT, MAX, MIN) ignore NULL values in calculations. Only COUNT(*) includes rows with NULLs because it counts all rows regardless of column values. This behavior prevents NULL from skewing aggregate results.