Multiple choice technology databases

Null vales are displayed last in case of ascending and first in case of desc sequences

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL, NULL values are treated as 'larger' than any non-NULL value for sorting purposes. When sorting in ascending order (ASC), NULL values appear at the end because they compare as greater than all actual values. When sorting in descending order (DESC), NULL values appear at the beginning for the same reason. This behavior is consistent across most major RDBMS implementations.

Keep practicing — related questions