Oracle 1Z0-071 Exam - Topic 15 Question 124 Discussion

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

Question #: 124
Topic #: 15

[All 1Z0-071 Questions]

Which statement will execute successfully?

ASELECT 1, 2 FROM DUAL
UNION
SELECT 3, 4 FROM DUAL
ORDER BY 1, 2;

BSELECT 3 FROM DUAL
UNION
SELECT 4 FROM DUAL
ORDER BY 3 ;

CSELECT 1, 2 FROM DUAL
UNION
SELECT 3, 4 FROM DUAL
ORDER BY 3, 4;

DSELECT 1 FROM DUAL
UNION
SELECT 2 FROM DUAL
ORDER BY 1, 2;

Show Suggested Answer

Suggested Answer: B

B . True. This statement will execute successfully because it has a single column in the SELECT statements combined with UNION, and the ORDER BY clause is referencing a valid column in the result set.

A is incorrect because it uses an ORDER BY clause with two columns, which is not allowed when the SELECT statements have only one column each. C is incorrect for the same reason as A; it references columns that do not exist in the result set. D is incorrect because it attempts to ORDER BY a second column, which does not exist in the result of the union.

by Shenika at Nov 23, 2025, 01:43 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Nakisha

5 hours ago

D is simple, but it might not order properly.

upvoted 0 times

...

Josue

5 days ago

A seems good, but what about D?

upvoted 0 times

...

Candra

10 days ago

Surprised that A is the only valid one!

upvoted 0 times

...

Latia

29 days ago

Wait, how does B even make sense?

upvoted 0 times

...

Cordie

1 month ago

A) is the only one that works!

upvoted 0 times

...

Erasmo

1 month ago

Ah, the age-old SQL question - when in doubt, just ORDER BY everything!

upvoted 0 times

...

Oren

1 month ago

Option C is not correct. It will fail because the ORDER BY clause references columns that are not in the SELECT list.

upvoted 0 times

...

Nan

2 months ago

Option B is not correct. It will fail because the ORDER BY clause references a column that is not in the SELECT list.

upvoted 0 times

...

Cordie

2 months ago

Option D is also a valid answer. It will execute successfully as it orders the results by the first and second columns.

upvoted 0 times

...

Viola

2 months ago

Option A is the correct answer. It will execute successfully as it orders the results by the first and second columns.

upvoted 0 times

...

Danilo

2 months ago

I’m confused about option B because it tries to order by a column that doesn't exist in the SELECT.

upvoted 0 times

...

Beth

2 months ago

I practiced a similar question where the ORDER BY had to match the number of selected columns. I feel like D might be tricky.

upvoted 0 times

...

Zita

3 months ago

I think option A looks familiar, but I'm not sure if it will work since it has two columns in the ORDER BY.

upvoted 0 times

...

Eden

3 months ago

I remember that the ORDER BY clause should reference columns that are in the SELECT statement.

upvoted 0 times

...

Elly

3 months ago

This is a good test of my SQL knowledge. I'll methodically evaluate each option and think about the expected output to determine which one will execute successfully.

upvoted 0 times

...

Cherry

3 months ago

I'm not entirely sure about this one. The ORDER BY clause has me a bit stumped. I'll need to review the SQL fundamentals and then take another look at the options.

upvoted 0 times

...

Nickole

3 months ago

Okay, I got this. The key is to understand that the ORDER BY clause applies to the entire result set, not just the individual SELECT statements. I'll analyze each option carefully.

upvoted 0 times

...

Mohammad

3 months ago

I think A is correct. It uses valid columns.

upvoted 0 times

...

Corrie

4 months ago

D looks good too, but I think it might fail.

upvoted 0 times

...

Leigha

4 months ago

Totally agree, A is the right choice.

upvoted 0 times

...

Daryl

4 months ago

Hmm, this looks tricky. I'm a bit confused about the ORDER BY clauses and how they'll interact with the UNION. I'll need to think this through step-by-step.

upvoted 0 times

...

Jaime

4 months ago

I think I know how to approach this one. I'll carefully read through each option and think about the SQL syntax and what the ORDER BY clause is doing in each case.

upvoted 0 times

...