Question

State whether the following statement is True or False :
The MOD() function in SQL returns the quotient of division operation between two numbers.

Hint:

Remember — MOD() = remainder. Use DIV or / for the quotient.

Answer 1

The MOD() function in SQL is used to calculate the remainder of the division of one number by another, not the quotient.
In other words, it performs a modulo operation.
For example:

SELECT MOD(10, 3);

The result is 1 because 10 divided by 3 gives a quotient of 3 and a remainder of 1.
So, the function returns the remainder, not the quotient.
Therefore, the given statement is incorrect — it should say remainder, not quotient.
Hence, the correct answer is False.