SQL ORDER BY Clause MCQ Sorting Data Practice Questions

Direction: Choose the correct option

SELECT * FROM employees ORDER BY salary ASC;

What does ASC do?

A. Alphabetical order

B. Ascending order (low to high)

C. Descending order

D. Random order

Direction: Choose the correct option

SELECT * FROM products ORDER BY price DESC;

How will results be sorted?

A. Most expensive first

B. Random

C. Cheapest first

D. Alphabetically

Direction: Choose the correct option

SELECT * FROM employees ORDER BY department ASC, salary DESC;

How is this sorted?

A. Department ascending, then salary descending

B. Salary ascending, then department

C. Department only

D. Salary only

Direction: Choose the correct option

SELECT * FROM customers ORDER BY country, name;

What is the default sort order?

A. Ascending for both

B. Error

C. Country ascending, name descending

D. Descending for both

Direction: Choose the correct option

SELECT name, salary, salary*12 AS annual FROM employees ORDER BY annual DESC;

What is being sorted?

A. Calculated annual column

B. Employee ID

C. Salary column

D. Name column

Quipoin Menu