Multiple choice technology databases

Which of the following are Scalar functions?

  1. MAX( )

  2. MID( )

  3. SUM( )

  4. NOW( )
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

Scalar functions operate on single values and return single values. MID() extracts a substring from a text value, and NOW() returns the current timestamp - both are scalar. MAX() and SUM() are aggregate functions that operate on multiple rows and return summary values.

Keep practicing — related questions