Free Mock Test : SQL : SQL Order By (Test 1)

Question : Which clause is used to sort the result-set in SQL?

GROUP BY

SORT BY

ORDER BY

ARRANGE BY

Question : What is the default sorting order of ORDER BY?

DESC

RANDOM

ASC

LIMIT

Question : Which keyword is used for descending order sorting?

DOWN

DESC

DORDER

REVERSE

Question : Which query sorts employee names alphabetically?

SELECT * FROM employees ORDER BY name;

SELECT * FROM employees SORT name;

SELECT * FROM employees GROUP BY name;

SELECT * FROM employees ARRANGE BY name;

Question : What will the following query do?

SELECT * FROM products
ORDER BY price DESC;

Sort by lowest price

Sort randomly

Sort by highest price first

Group by price

Question : Which statement about ORDER BY is TRUE?

It deletes records

It filters rows

It sorts rows

It creates tables

Question : Which clause is commonly used with ORDER BY to restrict output rows?

WHERE

LIMIT

HAVING

DISTINCT

Question : What does the following query return?

SELECT * FROM students
ORDER BY marks DESC
LIMIT 1;

Lowest marks

Random student

Highest marks student

All students

Question : Which query sorts data randomly in MySQL?

ORDER BY RAND()

ORDER BY RANDOMIZE()

ORDER BY RANDOM

ORDER BY SHUFFLE()

Question : Which function is commonly used in PostgreSQL for random ordering?

RAND()

RANDOM()

RANDOMIZE()

SHUFFLE()

Question : Which query sorts by two columns?

SELECT * FROM emp
ORDER BY dept, salary;

SELECT * FROM emp GROUP BY dept, salary;

SELECT * FROM emp SORT dept salary;

SELECT * FROM emp ORDER dept salary;

Question : What is the sorting priority here?

ORDER BY department ASC, salary DESC;

Salary first

Department first

Random order

Name first

Question : Which query gives the top 3 highest salaries?

SELECT * FROM emp
LIMIT 3;

SELECT * FROM emp
ORDER BY salary ASC
LIMIT 3;

SELECT * FROM emp
ORDER BY salary DESC
LIMIT 3;

SELECT * FROM emp
GROUP BY salary
LIMIT 3;

Question : Which clause must come after ORDER BY?

WHERE

SELECT

LIMIT

FROM

Question : What happens if duplicate values exist in the sorted column?

SQL throws error

SQL removes duplicates

Duplicate values remain together

Table is deleted

Question : Which query sorts names from Z to A?

ORDER BY name ASC

ORDER BY name DESC

ORDER BY name RANDOM

ORDER BY name LIMIT

Question : Which symbol separates multiple columns in ORDER BY?

Semicolon ;

Colon :

Comma ,

Dot .

Question : Which query returns 5 random records in MySQL?

SELECT * FROM emp
ORDER BY RAND()
LIMIT 5;

SELECT * FROM emp
LIMIT 5 RANDOM;

SELECT * FROM emp
ORDER RANDOM 5;

SELECT * FROM emp
GROUP BY RAND();

Question : Can ORDER BY be used on columns not shown in SELECT?

No

Only in Oracle

Yes

Only with GROUP BY

Question : Which query correctly sorts by department ascending and name descending?

ORDER BY department ASC, name DESC;

ORDER department, name;

SORT BY department ASC, name DESC;

ORDER BY ASC department, DESC name;

Free Mock Test - SQL : SQL Order By (Test 1)

Cookies & Disclaimer