Oracle
1Z0-047 · Question #202
1Z0-047 Question #202: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #202. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the descriptions of the EMPLOYEES and DEPARTMENTS tables. The following SQL statement was executed: SELECT e.department_id, e.job_id, d.location_id, sum(e.salary) total, GROUPING(e. department_id) GRP_DEPT, GROUPING(e.job_id) GRPJOB, GROUPING(d. location_id) GRP_LOC FROM employees e JOIN departments d ON e.department_id = d.department_id GROUP BY ROLLUP (e.department_id, e.job_id, d.location_id); View the Exhibit2 and examine the output of the command. Which two statements are true regarding the output? (Choose two.)
Exhibits
Options
- AThe value 1 in GRP_LOC means that the LOCATION_ID column is taken into account to generate the
- BThe value 1 in GRP_JOB and GRP_LOC means that JOB_ID and LOCATION_ID columns are not taken
- CThe value 1 in GRP_JOB and GRP_LOC means that the NULL value in JOB_ID and LOCATION_ID
- DThe value 0 in GRP_DEPT, GRP_JOB, and GRP_LOC means that DEPARTMENT_ID, JOB_ID, and
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.