Exam 1z0-071 topic 1 question 237 discussion

Actual exam question from Oracle's 1z0-071

Question #: 237
Topic #: 1

Examine these statements which execute successfully:

Both statements display departments ordered by their average salaries.

Which two are true? (Choose two.)

A. Both statements will execute successfully if you add E.AVG_SAL to the select list.
B. Both statements will display departments with no employees.
C. Only the second statement will execute successfully if you add E.AVG_SAL to the select list.
D. Only the first statement will display departments with no employees.
E. Only the second statement will display departments with no employees.
F. Only the first statement will execute successfully if you add E.AVG_SAL to the select list.

Show Suggested Answer

Suggested Answer: CD 🗳️

by NB196 at Feb. 25, 2024, 1:09 p.m.

Comments

Submit Cancel

khaleesi89

1 year ago

Selected Answer: 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

upvoted 2 times

...