Bird
0
0

Which of the following is TRUE about scalar user-defined functions in SQL?

easy📝 Conceptual Q2 of 15
SQL - Stored Procedures and Functions
Which of the following is TRUE about scalar user-defined functions in SQL?
AThey return a single value
BThey return multiple rows
CThey cannot accept parameters
DThey automatically update tables
Step-by-Step Solution
Solution:

  1. Step 1: Define scalar UDF behavior

    Scalar UDFs return exactly one value, such as a number or string.

  2. Step 2: Evaluate other options

    Returning multiple rows is for table-valued functions, parameters are allowed, and UDFs do not update tables automatically.

  3. Final Answer:

    They return a single value -> Option A

  4. Quick Check:

    Scalar UDF = single value return [OK]
Quick Trick: Scalar UDFs always return one value [OK]
Common Mistakes:
  • Confusing scalar with table-valued functions
  • Believing UDFs cannot take inputs
  • Assuming UDFs modify data automatically

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Window Functions - Moving averages with window frames - Quiz 2easy CASE Expressions - COALESCE and NULLIF as CASE shortcuts - Quiz 4medium Common Table Expressions (CTEs) - CTE referencing another CTE - Quiz 5medium Indexes and Query Performance - Index impact on INSERT and UPDATE - Quiz 11easy Indexes and Query Performance - How an index works (B-tree mental model) - Quiz 2easy SQL Security Basics - Parameter binding mental model - Quiz 5medium Stored Procedures and Functions - Why stored procedures are needed - Quiz 11easy Window Functions Fundamentals - OVER clause with PARTITION BY - Quiz 13medium Window Functions Fundamentals - NTILE for distribution - Quiz 10hard Window Functions Fundamentals - RANK and DENSE_RANK difference - Quiz 1easy