Multiple choice technology databases

What will be the default sort order if nothing is specified explicitly in the SELECT statement?

  1. ASCENDING

  2. DESCENDING

  3. RANDOM

  4. PHYSICAL

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL ORDER BY defaults to ASCENDING order if no direction is specified. This applies to all data types - numbers sort smallest to largest, text A to Z, dates earliest to latest.