Quiz for WHERE Clause

Q1: Which SQL clause is used to filter records before grouping or aggregation?

A. HAVING B. WHERE C. GROUP BY D. ORDER BY

Q2: Which SQL clause is used to filter records?

A. SELECT B. WHERE C. ORDER BY D. GROUP BY

Q3: Which operator is used in a WHERE clause for pattern matching?

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

Q4: How do you filter rows where age is greater than 25?

A. WHERE age > 25 B. WHERE age < 25 C. WHERE age = 25 D. WHERE age != 25

Q5: Which of the following is a valid WHERE clause?

A. WHERE salary B. WHERE = salary C. WHERE salary > 50000 D. salary WHERE > 50000

Q6: To find names starting with "A", which clause is used?

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

Q7: How do you use WHERE with multiple conditions?

A. WHERE cond1 AND cond2 B. WHERE cond1 + cond2 C. WHERE cond1 OR cond2 AND D. WHERE (cond1, cond2)

Q8: Which keyword is used with WHERE to match multiple values?

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

Q9: How to filter employees with salary between 3000 and 6000?

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

Q10: What does WHERE 1=1 return?

A. All rows B. No rows C. Rows with value 1 D. Rows with NULL

Q11: What does WHERE 1=0 return?

A. All rows B. No rows C. Rows with NULL D. Rows with value 0

Q12: Which is true about WHERE vs HAVING?

A. WHERE works after grouping B. HAVING works before grouping C. WHERE filters rows, HAVING filters groups D. Both are same

Q13: Can WHERE clause be used with DELETE statement?

A. Yes B. No C. Only with SELECT D. Only with UPDATE

Q14: Which clause limits rows returned based on a condition?

A. GROUP BY B. HAVING C. ORDER BY D. WHERE

Q15: Is WHERE mandatory in SELECT query?

A. Yes B. No C. Only with JOIN D. Only with COUNT()

Q16: What is the result of WHERE NULL?

A. All rows B. No rows C. Error D. Only NULL values

Q17: Which clause is correct for checking NULL?

A. WHERE column = NULL B. WHERE column IS NULL C. WHERE NULL = column D. WHERE column == NULL

Q18: How do you check for NOT NULL in WHERE?

A. WHERE column != NULL B. WHERE column NOT NULL C. WHERE column IS NOT NULL D. WHERE column <> NULL

Q19: Can WHERE use arithmetic operations?

A. No B. Only in SELECT C. Yes D. Only in GROUP BY

Q20: Which one is NOT a comparison operator for WHERE?

A. = B. != C. LIKE D. FROM

Q21: What is the result of: SELECT * FROM users WHERE age = 25;

A. All users B. Users with age 25 C. Users older than 25 D. Users younger than 25