Oracle Exam 1Z0-071 Topic 15 Question 101 Discussion

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

Question #: 101
Topic #: 15

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 last SELECT of the compound query

BThe first NUMBER column in the first SELECT of the compound query

CThe first VARCHAR2 column in the first SELECT of the compound query

DThe first column in the first SELECT of the compound query

EThe first NUMBER or VARCHAR2 column in the last SELECTof the compound query

Show Suggested Answer

Suggested Answer: A, B

by Mozell at Sep 07, 2024, 05:20 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

5 days ago

I'm not sure about this one. I was thinking it might be option B, but now I'm second-guessing myself. Sorting SQL queries can be tricky!

upvoted 0 times

...

17 days ago

But what if the last SELECT has a VARCHAR2 column as the first one?

upvoted 0 times

...

19 days ago

I disagree, I believe it is the first NUMBER column in the first SELECT.

upvoted 0 times

...

21 days ago

I think option D is the correct answer. The first column in the first SELECT of the compound query should be the default for sorting the output.

upvoted 0 times

5 days ago

I agree, option D is the correct answer.

upvoted 0 times

...

28 days ago

I think the default column for sorting output is the first column in the last SELECT.

upvoted 0 times

...