Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 228

Examine these statements which execute successfully:

Both statements display departments ordered by their average salaries.

Which two are true? (Choose two.)

Both statements will execute successfully if you add E.AVG_SAL to the select list.

Both statements will display departments with no employees.

Only the second statement will execute successfully if you add E.AVG_SAL to the select list.

Only the first statement will display departments with no employees.

Only the second statement will display departments with no employees.

Only the first statement will execute successfully if you add E.AVG_SAL to the select list.

Correct Answer: B, C

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.

Discussion

khaleesi89Options: BC

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

NB196

Actually, I think C & D are the correct answers

NB196Options: BC

B & C are the correct answers

ogi33Options: DE

D E tested

ogi33

sorry F not E

ogi33

omg of course only B C

ogi33

finally C D sorry for chaos english english