In Oracle SQL, set operations like UNION, UNION ALL, INTERSECT, and MINUS can be used to combine results from different queries:
* Option A:
* Combining results using UNION ALL followed by ORDER BY will execute successfully because UNION ALL allows duplicate rows and ORDER BY can be used to sort the combined result set.
* Option E:
* Similar to option A, UNION ALL combines all rows from the two selects and allows ordering of the results.
* Option G:
* UNION combines the results from two queries and removes duplicates, and ORDER BY can be used to sort the final result set.
Options B, C, D, and F are incorrect because:
* Option B: You cannot intersect different columns (ORDER_ID with INVOICE_ID).
* Option C: Incorrect column names and syntax with ORDER BY.
* Option D: ORDER BY cannot be used before a set operator like INTERSECT.
* Option F: ORDER BY cannot be used directly after a MINUS operator without wrapping the MINUS operation in a subquery.