Multiple choice technology databases

NULL values are ingnored for all SQ: 2008 aggregate functions.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Under the SQL standard, aggregate functions (like SUM, AVG, MIN, MAX, and COUNT) ignore NULL values in their evaluation, except for COUNT(). However, the prompt contains a typographical error ('ingnored', 'SQ: 2008'), and if COUNT is counted as an aggregate function, not *all ignore NULLs. Given standard exam content, the intended answer is True, but the statement has minor errors.

Keep practicing — related questions