Question

Which SQL function will return the following output:
mysql> Select __?__ (53, 10); 
output __3

• A. Truncate
• B. ROUND
• C. MOD
• D. POW

Hint:

The \texttt{MOD()} function is useful when you need to find remainders in division operations in SQL queries.

Answer 1

The Correct Option is C

The SQL function \texttt{MOD()} returns the remainder of a division operation. In this case, \texttt{MOD(53, 10)} gives the remainder when 53 is divided by 10, which results in 3. Therefore, the correct function for this query is \texttt{MOD()}.