View the Exhibitl 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 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
B.
The value 1 in GRP_LOC means that the LOCATION_ID column is taken into account to
generate the subtotal.
C.
The value 1 in GRPJOB and GRP_LOC means that JOB_ID and LOCATION_ID
columns are not taken into account to generate the subtotal.
D.
The value 1 in GRPJOB and GRP_LOC means that the NULL value in JOBJD and
LOCATIONJD columns are taken into account to generate the subtotal.
Explanation: