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

IN

Answer

LIKE

Answer

EXISTS

Question 2

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

Accepted Answer

Returns rows where salary matches any value in the list

Answer

Returns rows where salary equals all three values

Answer

Returns rows where salary is between 3000 and 5000

Answer

Returns rows where salary is none of the listed values

Question 3

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

Accepted Answer

WHERE name LIKE 'A%'

Answer

WHERE name LIKE '%A'

Answer

WHERE name = 'A%'

Answer

WHERE name LIKE '_A'

Question 4

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

Accepted Answer

WHERE email IS NULL

Answer

WHERE email = NULL

Answer

WHERE email = ''

Answer

WHERE email != NULL

Question 5

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

Accepted Answer

Only rows where both conditions are true

Answer

Rows where either condition is true

Answer

Rows where neither condition is true

Answer

All rows regardless of conditions

Question 6

Which wildcard in LIKE matches exactly one single character?

Accepted Answer

Underscore (_)

Answer

Percent (%)

Answer

Asterisk (*)

Answer

Question mark (?)

Question 7

What does WHERE NOT (status = 'active') return?

Accepted Answer

Rows where status is not 'active'

Answer

Rows where status is 'active'

Answer

Only rows where status is NULL

Answer

All rows in the table