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?

  1. A.

    POWER (16, 2)

  2. B.

    POWER (16, 4)

  3. C.

    POWER (16, 0.5)

  4. 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.

Explore the full course: Bpsc