SQL Sorting and Limiting Results 2

Question 1

By default, in which direction does ORDER BY sort results?

Accepted Answer

Ascending (ASC)

Answer

Descending (DESC)

Answer

Random order

Answer

Insertion order

Question 2

Which clause limits the number of rows returned in standard MySQL/PostgreSQL?

Accepted Answer

LIMIT

Answer

TOP

Answer

ROWNUM

Answer

FETCH ONLY

Question 3

How do you sort by 'last_name' ascending and then 'first_name' descending?

Accepted Answer

ORDER BY last_name ASC, first_name DESC

Answer

ORDER BY last_name, first_name

Answer

ORDER BY last_name DESC, first_name

Answer

SORT BY last_name, first_name DESC

Question 4

In SQL Server, which keyword limits the number of rows returned?

Accepted Answer

TOP

Answer

LIMIT

Answer

FIRST

Answer

MAX

Question 5

What does ORDER BY 2 mean in a query?

Accepted Answer

Sort by the second column in the SELECT list

Answer

Sort by a column named '2'

Answer

Return only 2 rows

Answer

Sort the second table

Question 6

Which query returns rows 11–20 in PostgreSQL?

Accepted Answer

LIMIT 10 OFFSET 10

Answer

LIMIT 10 SKIP 10

Answer

LIMIT 11 TO 20

Answer

OFFSET 20 LIMIT 10

Question 7

Without an ORDER BY clause, the order of returned rows is:

Accepted Answer

Not guaranteed

Answer

Always by primary key

Answer

Always insertion order

Answer

Always alphabetical