SQL SELECT Statement MCQ Advanced SELECT Practice Questions

Direction: Choose the correct option

SELECT * FROM employees WHERE salary > 50000;

What does this query return?

A. All salaries

B. All employees

C. Employees with salary > 50000

D. Employees with salary < 50000

Direction: Choose the correct option

SELECT name, salary FROM employees WHERE department = 'IT' AND salary > 60000;

How many conditions in WHERE?

A. Three

B. One

D. Two

Direction: Choose the correct option

SELECT * FROM products WHERE category = 'Electronics' OR category = 'Clothing';

What does OR do?

A. At least one must be true

B. Only first matters

C. Neither can be true

D. Both conditions must be true

Direction: Choose the correct option

SELECT * FROM employees WHERE NOT department = 'IT';

What will this return?

A. No employees

B. All employees

C. Non-IT department employees

D. IT department employees

Direction: Choose the correct option

SELECT * FROM orders WHERE (status = 'Pending' OR status = 'Processing') AND total > 100;

What is the purpose of parentheses?

A. Required for AND

B. Group conditions for correct logic

C. Make query faster

D. No purpose

Quipoin Menu