Multiple choice technology databases

The o/p of the below query.. select 0/1 from dual group by dummy;

  1. 0

  2. 1

  3. NULL

  4. Error: divisor is equal to zero

  5. Error: Not a GROUP BY clause

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

In SQL, 0 divided by 1 equals 0. The GROUP BY clause is valid here because DUAL has a DUMMY column. Oracle performs integer arithmetic, so 0/1 evaluates to 0, not a decimal.