Prev Question
Next Question

View the Exhibit1 and examine the descriptions of the EMPLOYEES and DEPARTMENTS tables.

5a10496f7b9cf - Which two statements are true regarding the output?

SELECT e.department_id, e.job_id, d.location_id, sum(e.salary) total GROUPING(e.department_id) GRP_DEPT,
GROUPING(e.job_id) GRP_JOB,
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.

5a10496f8c2a3 - Which two statements are true regarding the output?

Which two statements are true regarding the output? (Choose two.)

A.
The value 1 in GRP_LOC means that the LOCATION_ID column is taken into account to generate the subtotal.

B.
The value 1 in GRP_JOB and GRP_LOC means that JOB_ID and LOCATION_ID columns are not taken into account to generate the subtotal.

C.
The value 1 in GRP_JOB and GRP_LOC means that the NULL value in JOB_ID and LOCATION_ID columns are taken into account to generate the subtotal.

D.
The value 0 in GRP_DEPT, GRP_JOB, and GRP_LOC means that DEPARTMENT_ID, JOB_ID, and LOCATION_ID columns are taken into account to generate the subtotal.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *