Multiple choice technology databases

You can use Avg or Sum group functions for any numeric data

  1. True

  2. False

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

AVG and SUM functions only work on numeric data types. They cannot be applied to text, date, or other non-numeric data types. Attempting to use them on strings or dates will result in an error.

AI explanation

AVG and SUM are aggregate functions restricted to numeric column types (like NUMBER); they can't be applied to arbitrary numeric-looking or date/character data without explicit conversion. So the blanket claim that they work "for any numeric data" overstates their applicability, making the statement false.