Multiple choice technology databases

select max(5)*min(5)/avg(5) from dual group by dummy; o/p:

  1. 5

  2. 25

  3. 125

  4. 1

  5. Error: Syntax error

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

MAX(5), MIN(5), and AVG(5) all return 5 because the aggregate functions operate on a single value. So 5*5/5 = 5. The GROUP BY is valid.