Oracle
1Z0-082 · Question #144
Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?
The correct answer is A. the first column in the first select of the compound query. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?
Options
- 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
How the community answered
(25 responses)- A72% (18)
- B8% (2)
- D4% (1)
- E16% (4)
Topics
#SET operators#INTERSECT#compound queries#default sort order
Community Discussion
No community discussion yet for this question.