Oracle 1Z0-082 Exam - Topic 1 Question 127 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 127
Topic #: 1

Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

Athe first column in the first select of the compound query

Bthe first varchab2 column in the first select of the compound query

Cthe first number column in the first select of the compound query

Dthe first number or varchar2 column in the last select of the compound query

Ethe first column in the last select of the compound query

Show Suggested Answer

Suggested Answer: A

by Daniel at Mar 07, 2026, 08:34 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

4 hours ago

I feel like it might be the first varchar2 column in the first select, but I can't recall if that applies to all cases.

upvoted 0 times

...

5 days ago

I remember practicing a question where the sorting was determined by the last select's first column. Could it be option E?

upvoted 0 times

...

10 days ago

I think the default sorting is based on the first column of the first select, but I'm not entirely sure.

upvoted 0 times

...