Question

Single row functions are also known as ________ functions.

• A. Multi row
• B. Group
• C. Mathematical
• D. Scalar

Hint:

Remember: Single row functions = Scalar functions (work on each row individually). Multi-row functions = Aggregate functions (work on groups of rows).

Answer 1

The Correct Option is D

Step 1: Understanding single row functions.
Single row functions operate on a single row and return one value for each row processed. Examples include \texttt{UPPER()}, \texttt{LOWER()}, \texttt{ROUND()}, \texttt{LENGTH()}, etc.
Step 2: Check other types.
- Multi-row / Group functions: Operate on a set of rows and return a single result (e.g., \texttt{SUM}, \texttt{AVG}, \texttt{COUNT}).
- Mathematical: A category of functions, but not the general synonym.
- Scalar: Correct synonym, since they return one value per row.

Step 3: Conclusion.
Hence, single row functions are also known as Scalar functions.
Final Answer: \[ \boxed{\text{Scalar Functions}} \]