Skip to content
Question

Q.Which SQL function calculates a^b? (A) MOD() (B) POWER() (C) RAISE() (D) ROUND()

CBSECBSE Class XII Board 2025MCQ· 1mImportance★★★★★
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

The SQL function that calculates a raised to the power b is POWER(), which takes two arguments — the base and the exponent — and returns the result.

In SQL, mathematical operations are handled by a set of built-in functions. When you need to raise one number to the power of another — say, 2 to the 3rd power to get 8 — you are performing an exponentiation. The function designed specifically for this is POWER().

POWER() takes two arguments: the base (the number you want to raise) and the exponent (the power to which you raise it). For example, POWER(2, 3) returns 8. This is the standard SQL function across most database systems, including MySQL, PostgreSQL, and Oracle.

Let's look at the other options to see why they are incorrect.

Note

MOD() returns the remainder of a division (e.g., MOD(10, 3) = 1). ROUND() rounds a number to a specified number of decimal places. Neither performs exponentiation. …

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.