View the Exhibit l 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.)
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
LOCATIONJD columns are taken into account to generate the subtotal.
D.
The value 0 in GRP_DEPT, GRPJOB, and GRP_LOC means that DEPARTMENT_ID, JOB_ID,
and LOCATION_ID columns are taken into account to generate the subtotal