SQL Filtering with WHERE Clause 2

Question 1

Which operator checks whether a column value falls within an inclusive range of two values?

Accepted Answer

BETWEEN

Answer

BETWEEN tests an inclusive range, so BETWEEN 10 AND 20 includes both 10 and 20.

Question 2

What does WHERE salary IN (3000, 4000, 5000) do?

Accepted Answer

Returns rows where salary matches any value in the list

Answer

IN returns rows where the column matches any one of the listed values.

Question 3

Which clause correctly filters for names starting with the letter 'A'?

Accepted Answer

WHERE name LIKE 'A%'

Answer

The % wildcard after A matches any sequence of characters following A.

Question 4

How do you select rows where the email column has no value?

Accepted Answer

WHERE email IS NULL

Answer

NULL comparisons require IS NULL because = NULL never evaluates true.

Question 5

In WHERE age > 18 AND city = 'NYC', which rows are returned?

Accepted Answer

Only rows where both conditions are true

Answer

AND requires both conditions to be true for a row to be included.

SQL Practice Test