Oracle
1Z0-047 · Question #256
View the Exhibit and examine the description for EMPLOYEES and DEPARTMENTS tables. Evaluate the following SQL statement: SELECT e.department_id, e.job_id, d.location_id, sum(e. salary) total FROM…
The correct answer is A. The output would display the total salary for all the departments. B. The output would display the total salary for all the JOB_IDs in a department. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the description for EMPLOYEES and DEPARTMENTS tables. Evaluate the following SQL statement:
SELECT e.department_id, e.job_id, d.location_id, sum(e. salary) total FROM employees e JOIN departments d ON e.department_id = d.department_id GROUP BY CUBE (e.department_id, e.job_id, d.location_id); Which two statements are true regarding the output of this command? (Choose two.)
Exhibit
Options
- AThe output would display the total salary for all the departments.
- BThe output would display the total salary for all the JOB_IDs in a department.
- CThe output would display only the grand total of the salary for all JOB_IDs in a LOCATION_ID.
- DThe output would display the grand total of the salary for only the groups specified in the GROUP BY clause.
How the community answered
(29 responses)- A76% (22)
- C7% (2)
- D17% (5)
Community Discussion
No community discussion yet for this question.