Which of the following expression in SQL would calculate the square root of 16?
2025
Which of the following expression in SQL would calculate the square root of 16?
- A.
POWER (16, 2)
- B.
POWER (16, 4)
- C.
POWER (16, 0.5)
- D.
MOD (16)
Attempted by 860 students.
Show answer & explanation
Correct answer: C
To calculate the square root of 16 in SQL, we use the POWER function, which raises a number to a specified power. The square root of a number x is equivalent to x raised to the power of 0.5. Therefore, POWER(16, 0.5) gives √16 = 4. POWER(16, 2) computes 16² = 256, which is not the square root. MOD(16) is invalid because MOD requires two arguments: the dividend and the divisor. It cannot be used to compute square root.