Multiple choice technology databases

select avg(dummy) from dual; o/p:

  1. Error: Invalid Number

  2. Error: Invalid Character

  3. 0

  4. 1

  5. Error: divisor is equal to zero
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

AVG() requires numeric input, but DUMMY contains 'X' (a string value in DUAL). Oracle cannot convert 'X' to a number, raising ORA-01722: invalid number.

Keep practicing — related questions