LPIC-1 Exam 102 (Linux Administrator) — Question 14

Which of the following words is used to restrict the records that are returned from a SELECT SQL query based on a supplied criteria for the values in the records?

Answer options

• A. CASE
• B. FROM
• C. WHERE
• D. IF

Correct answer: C

Explanation

The correct answer is C, WHERE, which is specifically used in SQL to filter records based on given conditions. A. CASE is used for conditional logic, B. FROM specifies the table to query from, and D. IF is not a valid SQL clause for restricting records, making them incorrect options.