Multiple choice technology testing

If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default:

  1. There is no default value.

  2. DESC

  3. Random

  4. ASC
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL's ORDER BY clause uses ASC (ascending) as the default sort direction when no explicit ASC or DESC keyword is specified. This means values are arranged from lowest to highest (A-Z for text, 0-9 for numbers, earliest to latest for dates). To sort in descending order, you must explicitly specify DESC.

AI explanation

To answer this question, you need to understand the behavior of the SQL ORDER BY clause.

The ORDER BY clause is used to sort the result set of a SQL query. By default, if you don't specify ASC (ascending) or DESC (descending) after the ORDER BY clause, the following is used by default:

Option A) There is no default value - This option is incorrect. By default, when you don't specify ASC or DESC, there is a default sort order.

Option B) DESC - This option is incorrect. DESC is not the default sort order.

Option C) Random - This option is incorrect. There is no random default sort order.

Option D) ASC - This option is correct. When you don't specify ASC or DESC, the default sort order is ascending (ASC).

Therefore, the correct answer is option D.

Keep practicing — related questions