Question 22

Question

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

Accepted Answer

The first column in the first SELECT of the compound query

EmmaH · Answer

A is wrong, D. By default it's always the first column from the first SELECT in these compound queries.

Sara S. · Answer

Its D since Oracle falls back on the first column from the first SELECT for default sorting with set operators, unless you use ORDER BY. I'm pretty sure about this but open to being corrected if anyone has seen it act different.

Oracle 1Z0-071 Real Exam Questions [October 2026 Update] Quiz

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

Premium Access Includes