Multiple choice technology databases

which of the following denote single value function used in SQL

  1. AVG ( )

  2. SQRT ( )

  3. COUNT ( )

  4. All the Above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Single-value functions (also called scalar functions) operate on individual values and return a single value. SQRT() is a classic example - it takes one number and returns its square root. AVG() and COUNT() are aggregate functions that operate on multiple rows. Option D 'All the Above' is incorrect because it mixes scalar and aggregate functions.

Keep practicing — related questions