Question:

Which SQL function calculates $a^b$ ?

Show Hint

Use POWER() for exponentiation; for square root, use SQRT().
Updated On: July 22, 2025
  • MOD()
  • POWER()
  • RAISE()
  • ROUND()
Hide Solution
collegedunia
Verified By Collegedunia

The Correct Option is B

Solution and Explanation

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().
Was this answer helpful?
0
0

Top Questions on SQL Queries

View More Questions

CBSE CLASS XII Notification