Take this free SQL Intermediate MCQ quiz to test your database querying skills. Perfect for interview preparation and mastering core SQL concepts like joins, subqueries, group by, and more.

SQL Online Test | Free MCQs & Practice Quiz

Summarized sales data with regional subtotals and grand total.

Error because WITH ROLLUP cannot be used with WHERE.

Only regions where sales are greater than 1000.

Given the table Sales, what will the following query return?
SELECT Region, SUM(Sales) 
FROM Sales
WHERE Sales > 1000
GROUP BY Region
WITH ROLLUP;


Select departments having more than 10 employees

Returns employees reporting directly to their managers.

Returns a hierarchical tree structure of employees.

What does the following SQL query return?
SELECT EmployeeID, ManagerID
FROM Employees
CONNECT BY PRIOR EmployeeID = ManagerID;


What does the following return? SELECT COUNT(*) FROM employees;

SELECT * FROM users WHERE name LIKE '%A';

SELECT * FROM users WHERE name LIKE 'A%';

SELECT * FROM users WHERE name LIKE '_A';

What is the correct query to get users whose name starts with 'A'?

Returns departments with at least 10 employees.

Returns only employees with more than 10 years of experience.

What does this query do?
SELECT Department, COUNT(*) 
FROM Employees
GROUP BY Department
HAVING COUNT(*) > 10;


First non-null value from Phone, Email, or 'No Contact'.

Returns NULL if both Phone and Email are NULL.

What will this SQL query return?
SELECT Name, COALESCE(Phone, Email, 'No Contact') 
FROM Customers;


What is the purpose of the GROUP BY clause?

UPDATE students SET grade='A' WHERE marks > 85;

Returns the count of orders between the given dates.

Returns the count only if it's greater than 100.

What will be the output of the following SQL query?
SELECT COUNT(*)
FROM Orders
WHERE OrderDate BETWEEN '2024-01-01' AND '2024-12-31'
HAVING COUNT(*) > 100;


What will happen if you run the following query?
DELETE FROM Orders
WHERE OrderID IN (SELECT OrderID FROM Orders WHERE CustomerID = 5);


SELECT e.name, d.name FROM employees e JOIN departments d ON e.dept_id = d.id;

SELECT * FROM orders ORDER BY order_date DESC;

Returns employees with above-average salaries.

Returns employees with below-average salaries.

What does the following SQL query do?
SELECT *
FROM Employees
WHERE Salary > (SELECT AVG(Salary) FROM Employees);


What is the result of the following SQL statement?
SELECT NULL = NULL;

Returns the total salary for each department.

Returns an error due to the missing GROUP BY.

Returns the total salary of all employees

Returns one row per department with summed salaries.

What happens if you execute this SQL statement?
SELECT EmployeeID, Department, SUM(Salary) 
FROM Employees;


Assigns a unique rank without skipping numbers for duplicates.

Assigns the same rank for duplicate values but skips the next rank.

Returns the total number of rows in a table.

What is the purpose of the DENSE_RANK() function in SQL?

How do you get orders placed after Jan 1, 2024?

SELECT name FROM users WHERE EXISTS (SELECT * FROM orders WHERE orders.user_id = users.id);

SELECT name FROM users INNER JOIN orders ON users.id = orders.id;

SELECT name FROM users WHERE COUNT(orders.id) > 0;

SELECT DISTINCT name FROM users JOIN orders;

Which query gets names of users who placed at least one order?

SELECT * FROM products WHERE category != 'Grocery';

SELECT * FROM products WHERE category NOT IN ('Grocery');

SELECT * FROM products EXCEPT category = 'Grocery';

Which query returns products not in the 'Grocery' category?

SELECT FIRST 5 salary FROM employees ORDER BY salary DESC;

SELECT salary FROM employees ORDER BY salary DESC LIMIT 5;

SELECT TOP 5 * FROM employees ORDER BY salary DESC;

Select top 5 highest paid employees (SQL Server)

Which JOIN returns only matching rows from both tables?

SELECT salary FROM employees WHERE MAX(salary);

SELECT salary FROM employees ORDER BY salary LIMIT 1;

What query returns the highest salary from employees?

DELETE FROM orders WHERE status = 'cancelled';

SELECT * FROM products WHERE price BETWEEN 100 AND 200;

SELECT name, category FROM products NATURAL JOIN categories;

SELECT p.name, c.name FROM products p JOIN categories c ON p.cat_id = c.id;

SELECT name FROM products LEFT JOIN categories;

SELECT department, COUNT(*) FROM employees GROUP BY department;

Orders by count of employees in ascending order.

Orders by count of employees in descending order.

What is the result of the following query?
SELECT Department, COUNT(EmployeeID) 
FROM Employees 
GROUP BY Department 
ORDER BY 2 DESC;

Enter your number

SQL Intermediate Practice Test