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: Define Single-Row Functions.
Single-row functions process one row at a time, yielding a single output per row. Examples include \texttt{UPPER()}, \texttt{LOWER()}, \texttt{ROUND()}, and \texttt{LENGTH()}.
Step 2: Evaluate Alternative Function Types.
- Group Functions: Process multiple rows to produce a single aggregate result (e.g., \texttt{SUM}, \texttt{AVG}, \texttt{COUNT}).
- Mathematical Functions: A specific subset, not a general descriptor.
- Scalar Functions: This term is accurate, as they return one value for each processed row.

Step 3: Finalize the Terminology.
Therefore, single-row functions are also referred to as Scalar functions.
Final Answer: \[\boxed{\text{Scalar Functions}}\]