Which function limits a query's resulting output?

Which function limits a query's resulting output?

• A. Filter
• B. Limit
• C. Truncate
• D. Constrain

Answer: (A)

Filtering narrows what the query returns by applying a condition to each row. Only rows that meet the criteria pass through, which directly limits the resulting output to the subset you want. A separate limit function would only cap how many rows are returned, not choose which rows are included; truncation cuts data values rather than rows; constraining isn’t a standard term for this operation. Therefore, filtering is the operation that most directly limits the query’s output.

Filtering narrows what the query returns by applying a condition to each row. Only rows that meet the criteria pass through, which directly limits the resulting output to the subset you want. A separate limit function would only cap how many rows are returned, not choose which rows are included; truncation cuts data values rather than rows; constraining isn’t a standard term for this operation. Therefore, filtering is the operation that most directly limits the query’s output.