Multiple choice technology databases

You are sorting data in a table in you SELECT statement in descending order. The column you are sorting on contains NULL records, where will the NULL record appears?

  1. At the beginning of the list

  2. At the end of the list

  3. In the middle of the list

  4. At the same location they are listed in the unordered table
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When sorting in descending order (DESC), NULL values appear at the beginning of the result set in Oracle SQL, opposite to their placement in ascending sorts. This is consistent with Oracle's treatment of NULL as greater than any non-NULL value. The NULL records do not appear in the middle or retain their original table positions.

Keep practicing — related questions