Multiple choice technology

Sort order of output of join depends on

  1. Sort order of input to join

  2. maintain-order paramter

  3. sorted-input paramter

  4. Key Specifiers
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

The output sort order of a join depends on: (1) the sort order of inputs, (2) the maintain-order parameter (which preserves input ordering), and (3) the sorted-input parameter (which expects sorted inputs). Key specifiers define what to join ON, not how to sort the output.

Keep practicing — related questions