問題文
A query contains MOD(salary, bonus_divisor) and some rows hold a zero in bonus_divisor. The team expects those rows to fail. What does the function return for a row where the second argument is zero?
選択肢
- It returns a null for that row, because the function is defined to hand back a null whenever an argument it receives makes the division impossible.
- It returns a zero for that row, because the function is defined to hand back the divisor whenever the divisor it receives cannot divide the dividend.
- It returns the first argument unchanged, because the function is defined to hand back the dividend whenever the divisor it receives is zero.
- It raises a divisor is equal to zero error, because the function is defined to carry out the division before it takes the remainder of the result.