Question

Which SQL expression calculates the square root of 16?

• A. POWER(16,2)
• B. POWER(16,0.5)
• C. POWER(16,1)
• D. MOD(16)

Answer 1

The Correct Option is B

The SQL expression that calculates the square root of 16 is POWER(16, 0.5).

Additional Context:

• Mathematical Principle:
  • Square root is equivalent to raising to the power of 0.5
  • √x = x^(1/2)
• SQL Function Analysis:
  • POWER(16,0.5) (2): Correct calculation → 4
  • POWER(16,2) (1): Calculates 16² → 256
  • POWER(16,1) (3): Returns 16¹ → 16
  • MOD(16) (4): Missing parameters (modulo operation)
• Alternative Functions:
  • SQRT(16) - Direct square root function
  • POW(16,0.5) - Synonym in some databases
• Database Compatibility:
  • Works in MySQL, PostgreSQL, SQL Server, Oracle
  • Syntax consistent across platforms

Correct Answer: (2) POWER(16,0.5).