Quiz for Filtering with WHERE

Q1: What does the WHERE clause do in a SQL SELECT statement?

A. Sorts the output B. Filters rows based on a condition C. Groups rows by a column D. Joins multiple tables

Q2: Which of the following returns rows where the salary is greater than 5000?

A. SELECT * FROM emp WHERE salary < 5000; B. SELECT * FROM emp WHERE salary > 5000; C. SELECT * FROM emp WHERE salary = 5000; D. SELECT * FROM emp;

Q3: What does the BETWEEN operator do?

A. Filters rows in a specified range B. Sorts the result set C. Joins two tables D. Deletes records

Q4: Which operator is used to test for multiple values in a WHERE clause?

A. BETWEEN B. IN C. LIKE D. ANY

Q5: How do you filter names starting with "A"?

A. WHERE name = "A%" B. WHERE name LIKE "A%" C. WHERE name CONTAINS "A" D. WHERE name BETWEEN "A" AND "Z"

Q6: What does the LIKE "%son" do in SQL?

A. Finds values ending with "son" B. Finds values starting with "son" C. Finds exact match "son" D. Finds values containing "son"

Q7: What is the result of using NOT IN in a WHERE clause?

A. Selects only values that match a set B. Excludes values listed C. Includes NULL values D. Always returns empty set

Q8: Which condition correctly checks for NULL values?

A. WHERE col = NULL B. WHERE col != NULL C. WHERE col IS NULL D. WHERE col NOT NULL

Q9: How to filter employees not named "John"?

A. WHERE name <> "John" B. WHERE name != "John" C. WHERE name NOT "John" D. Both A and B

Q10: Which query filters employees with salary between 3000 and 6000?

A. WHERE salary IN (3000, 6000) B. WHERE salary BETWEEN 3000 AND 6000 C. WHERE salary = 3000 OR 6000 D. WHERE salary >= 3000

Q11: What is the output of: WHERE 1=1?

A. Filters nothing B. Selects no rows C. Selects all rows D. Causes error

Q12: Which operator is used to match part of a string?

A. LIKE B. IN C. BETWEEN D. EXISTS

Q13: Which keyword can combine multiple WHERE conditions?

A. JOIN B. ON C. AND/OR D. GROUP BY

Q14: Which condition finds employees with salary not between 4000 and 7000?

A. WHERE salary NOT BETWEEN 4000 AND 7000 B. WHERE salary < 4000 AND salary > 7000 C. WHERE salary = 4000 OR 7000 D. WHERE salary BETWEEN 7000 AND 4000

Q15: What does this query return? SELECT * FROM emp WHERE dept_id IS NOT NULL;

A. Rows with NULL dept_id B. All rows C. Rows with non-null dept_id D. Rows with dept_id = 0

Q16: How do you filter rows where name ends with "n"?

A. WHERE name LIKE "%n" B. WHERE name LIKE "n%" C. WHERE name = "n" D. WHERE name != "n%"

Q17: Which operator works as a wildcard for one character?

A. _ B. % C. $ D. #

Q18: Which statement excludes employees with dept_id = 5?

A. WHERE dept_id = 5 B. WHERE dept_id <> 5 C. WHERE NOT dept_id = 5 D. Both B and C

Q19: Which operator checks if a value exists in a subquery?

A. EXISTS B. LIKE C. BETWEEN D. IN

Q20: What does this query do: SELECT * FROM emp WHERE name LIKE "_a%";

A. Finds names with "a" as second letter B. Finds names starting with "a" C. Finds names ending with "a" D. Finds exact match "a"