Database Fundamentals — Question 17

This question requires that you evaluate the underlined text to determine if it is correct.
Use the FROM keyword in a SELECT statement to return rows that meet a specific condition.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

Answer options

• A. No change is needed
• B. ORDER BY
• C. UNION
• D. WHERE

Correct answer: D

Explanation

The correct answer is D, WHERE, because the WHERE clause is specifically used to filter records based on specified conditions in a SQL query. The FROM keyword does not filter records; it simply specifies the table from which to retrieve the data. Therefore, the other options do not appropriately address the requirement to filter rows based on conditions.