Loading

Quipoin Menu

Learn • Practice • Grow

sql / WHERE
mcq
Direction: Choose the correct option

Q1.

SELECT * FROM employees WHERE department IN ('IT', 'HR', 'Finance');
What does IN operator do?
A. Checks pattern
B. Checks range
C. Checks multiple possible values
D. Checks existence
Direction: Choose the correct option

Q2.

SELECT * FROM products WHERE price BETWEEN 100 AND 500;
What range does BETWEEN include?
A. 100 only
B. 500 only
C. 100 to 500 inclusive
D. 100 to 500 exclusive
Direction: Choose the correct option

Q3.

SELECT * FROM customers WHERE name LIKE 'A%';
What does '%' represent in LIKE?
A. Any number of characters
B. Exact match
C. Any single character
D. Start of string
Direction: Choose the correct option

Q4.

SELECT * FROM customers WHERE email LIKE '%@gmail.com';
Which emails will this find?
A. Emails ending with @gmail.com
B. Emails starting with @gmail.com
C. All Gmail emails
D. Only exact @gmail.com
Direction: Choose the correct option

Q5.

SELECT * FROM employees WHERE manager_id IS NULL;
What does IS NULL check for?
A. Zero value
B. NULL value
C. False value
D. Empty string