Question

Which SQL function calculates $a^b$ ?

• A. MOD()
• B. POWER()
• C. RAISE()
• D. ROUND()

Hint:

Use POWER() for exponentiation; for square root, use SQRT().

Answer 1

The Correct Option is B

In SQL, the POWER() function is used to raise one number to the power of another.
The syntax is:

POWER(a, b)

This returns $a^b$.
Example:

SELECT POWER(2, 3);

Result:

8

- MOD() returns the remainder of division, not exponentiation.
- RAISE() is not a standard SQL function for math operations; it is used in some contexts for exceptions.
- ROUND() rounds a number to a specified number of decimal places.
Thus, the correct function for exponentiation is POWER().