SQL LIMIT Clause MCQ Pagination Practice Questions

Direction: Choose the correct option

SELECT * FROM employees LIMIT 5;

What will this query return?

A. Last 5 employees

B. First 5 employees

C. Random 5

D. Employees with id 5

Direction: Choose the correct option

SELECT * FROM employees LIMIT 5 OFFSET 5;

What does OFFSET 5 do?

A. Returns last 5 rows

B. Skips last 5 rows

C. Skips first 5 rows

D. Returns first 5 rows

Direction: Choose the correct option

SELECT * FROM employees ORDER BY salary DESC LIMIT 3;

What will this return?

A. Lowest 3 salaries

B. First 3 employees

C. Random 3 employees

D. Highest 3 salaries

Direction: Choose the correct option

SELECT * FROM employees ORDER BY salary DESC LIMIT 3,3;

In MySQL, what does LIMIT 3,3 mean?

A. Return first 3 rows

B. Return rows 3 to 6

C. Return last 3 rows

D. Return 3 rows starting from row 3

Direction: Choose the correct option

SELECT * FROM employees WHERE department = 'IT' LIMIT 3;

What does this query do?

A. First 3 IT employees

B. Last 3 IT employees

C. First 3 employees in any department

D. All IT employees

Quipoin Menu