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_LOCFROM employees e JOIN departments dON e.department_id = d.department_idGROUP 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 GRPJOB 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 GRPJOB and GRP_LOC means that the NULL value in JOBJD 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
View the Exhibit and examine the descriptions of the EMPLOYEES and DEPARTMENTS tables.The following SQL statement was ex
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am