Quiz for BETWEEN

Q1: What does the SQL BETWEEN operator do?

A. Matches exact value B. Checks for null values C. Selects values within a range D. Filters rows with wildcards

Q2: What does the BETWEEN operator do in SQL?

A. Filters values within a range B. Filters only exact matches C. Sorts values D. Joins two tables

Q3: Which SQL clause is commonly used with BETWEEN?

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

Q4: How many values are provided to BETWEEN?

A. 1 B. 2 C. 3 D. Unlimited

Q5: Which of these is a valid usage of BETWEEN?

A. WHERE age BETWEEN 20 AND 30 B. WHERE salary BETWEEN C. WHERE id = BETWEEN 1 D. SELECT * BETWEEN 1 AND 5

Q6: Does BETWEEN include the boundary values?

A. Yes B. No C. Only lower bound D. Only upper bound

Q7: What will this return: SELECT * FROM students WHERE marks BETWEEN 50 AND 60?

A. Marks greater than 60 B. Marks equal to 50 only C. Marks between 50 and 60 inclusive D. All students

Q8: Can BETWEEN be used with text data?

A. Yes B. No C. Only with numbers D. Only with dates

Q9: What is the result of "WHERE name BETWEEN 'Adam' AND 'Mark'"?

A. Names starting with A only B. Names from Adam to Mark inclusive C. Error D. No rows returned

Q10: Can BETWEEN be used with NOT?

A. Yes B. No C. Only in MySQL D. Only with strings

Q11: What does "WHERE date BETWEEN '2024-01-01' AND '2024-12-31'" filter?

A. Dates outside the year 2024 B. Only January 2024 C. Dates within the year 2024 D. All dates

Q12: BETWEEN is case sensitive when used with?

A. Strings in MySQL B. Integers C. Dates D. It is not case sensitive

Q13: How does SQL interpret BETWEEN with dates?

A. Chronologically B. Alphabetically C. Randomly D. Numerically

Q14: What is the output of: SELECT * FROM products WHERE price BETWEEN 100 AND 200?

A. Products priced below 100 B. Products priced above 200 C. Products priced 100 to 200 D. All products

Q15: Which of these is invalid with BETWEEN?

A. Strings B. Integers C. Booleans D. Dates

Q16: Which result is true for WHERE score BETWEEN 60 AND 80?

A. Score = 59 B. Score = 80 C. Score = 81 D. Score < 60

Q17: BETWEEN works best in which clause?

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

Q18: Which is true about NOT BETWEEN?

A. It includes the range B. It excludes the range C. It inverts column values D. It sorts values

Q19: Which one uses BETWEEN correctly with strings?

A. WHERE name BETWEEN "John" AND "Steve" B. BETWEEN name FROM "John" TO "Steve" C. WHERE name EQUALS BETWEEN "John" AND "Steve" D. BETWEEN("John", "Steve")

Q20: If salary = 10000, will it match WHERE salary BETWEEN 5000 AND 10000?

A. Yes B. No C. Only if inclusive flag is set D. Only in PostgreSQL