A combination of operands and operators that yields a value for use in a query is called a

• A. Constant
• B. Clause
• C. Expression
• D. Block

Answer: (C)

In SQL, a combination of operands and operators that yields a value used in a query is an expression. Operands can be column names or literals, and operators include +, -, *, /, and comparison or other functional operators. Expressions can perform arithmetic, build strings, or return results from functions, and they can appear wherever a value is needed in a SQL statement—for example in the SELECT list, a WHERE condition, or an ORDER BY clause. A constant is just a fixed value and doesn’t involve any computation. A clause is a part of the statement’s syntax that introduces conditions or groupings (like a WHERE or GROUP BY). A block is a group of statements, typically used in scripts or stored procedures, not a single value. Therefore, the construct that yields a value in a query is an expression.