SQL Sorting and Limiting Results 4

Question 1

Can you use a column alias defined in SELECT inside ORDER BY?

Accepted Answer

Yes, in most databases

Answer

No, aliases are never allowed there

Answer

Only in WHERE

Answer

Only with subqueries

Question 2

Which query finds the top 3 highest-priced products?

Accepted Answer

ORDER BY price DESC LIMIT 3

Answer

ORDER BY price ASC LIMIT 3

Answer

LIMIT 3 ORDER BY price

Answer

ORDER BY price LIMIT TOP 3

Question 3

What is the risk of using LIMIT/OFFSET for pagination on large tables?

Accepted Answer

Large offsets get slower as they scan and skip rows

Answer

It returns wrong column types

Answer

It locks the table permanently

Answer

It ignores the WHERE clause

Question 4

Which expression sorts case-insensitively in many databases?

Accepted Answer

ORDER BY LOWER(name)

Answer

ORDER BY name CASELESS

Answer

ORDER BY name IGNORE CASE

Answer

ORDER BY name COLLATE BINARY

Question 5

Can ORDER BY use an expression like ORDER BY price * quantity?

Accepted Answer

Yes, expressions are allowed

Answer

No, only column names

Answer

Only if the expression is in SELECT

Answer

Only with aggregate functions

Question 6

In SQL Server, how do you get the top 10 percent of rows?

Accepted Answer

SELECT TOP 10 PERCENT

Answer

SELECT TOP 10%

Answer

LIMIT 10 PERCENT

Answer

SELECT PERCENT 10 TOP

Question 7

Which clause combination is required for reliable pagination?

Accepted Answer

ORDER BY with LIMIT/OFFSET

Answer

Just LIMIT/OFFSET

Answer

Just ORDER BY

Answer

GROUP BY with LIMIT