Oracle
1Z0-047 · Question #256
1Z0-047 Question #256: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #256. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.