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

The MOD function returns the remainder when one number is divided by another. For example, MOD(10, 3) returns 1 because 10 divided by 3 equals 3 with remainder 1. Option A describes division with quotient (DIV function), option B describes multiplication, and option D is incorrect as MOD is a standard SQL function.