Database Fundamentals — Question 122

Which keyword would you use in a select statement to return rows that meet a specific condition?

Answer options

• A. WHERE
• B. UNION
• C. ORDER BY
• D. FROM

Correct answer: A

Explanation

The correct keyword is WHERE, as it filters records based on specified conditions. UNION is used to combine the results of two or more SELECT statements, ORDER BY arranges the result set in a specified order, and FROM indicates the table from which to retrieve the data.