1z0-071 Exam - Question 228

Question

Examine these statements which execute successfully:Both statements display departments ordered by their average salaries. Which two are true? (Choose two. ).

Examice · Accepted Answer

Both statements will display departments with no employees, as both selections include 'departments d' which means they will list all departments regardless of whether they have employees or not. Only the second statement will execute successfully if you add E.AVG_SAL to the select list because it uses JOIN and GROUP BY correctly to associate department_id with its average salary.

NB196 · Answer

B & C are the correct answers

NB196 · Answer

Actually, I think C & D are the correct answers

khaleesi89 · Answer

Correct Answer: BC Tested
A->The first select returns ORA-00904 
D ->Wrong because both statement have d.* in the select list, so both will display departments with no employees
E-> Wrong like D
F -> Wrong like A

ogi33 · Answer

D E tested

1z0-071 Exam - Question 228

Discussion