Exam 1z0-071 topic 1 question 63 discussion

Actual exam question from Oracle's 1z0-071

Question #: 63
Topic #: 1

Examine the description of the EMPLOYEES table:

Which two queries return all rows for employees whose salary is greater than the average salary in their department? (Choose two.)
A.

B.

C.

D.

E.

Show Suggested Answer

Suggested Answer: BE

by Poke90 at March 8, 2023, 4:12 p.m.

Comments

Submit Cancel

Thameur01

2 months, 3 weeks ago

A,B and E by chatGpt

upvoted 1 times

...

ArslanAltaf

6 months ago

B & D is correct only. E is not

upvoted 1 times

ArslanAltaf

6 months ago

Correction - B, D and E all worked. All tested

upvoted 1 times

ogi33

5 months, 3 weeks ago

D execute but gives no corect data

upvoted 4 times

...

Poke90

1 year, 7 months ago

IN E, the column alias avg_salary from the sub query is used in the WHERE clause of the main query. Is that allowed?

upvoted 2 times

Eltelwany

1 year, 7 months ago

Yes, it is allowed. It follows from the order of the execution. Since the engine would execute the subquery first, it already knows what the alias refers to.

upvoted 3 times

...