Multiple choice technology databases

What does the MOD Function do?

  1. It divides both the values and gives the quotient.

  2. It multiplies both the values and gives the product.

  3. It divides both the values and gives the remainder.

  4. There is no such function.

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

MOD function returns the remainder after division. For example, MOD(10,3) = 1 because 10/3 = 3 remainder 1. Option A describes division with quotient (that's just / operator). Option B describes multiplication (that's * operator). Option D is false - MOD is a valid SQL function.