View the Exhibit and examine the descriptions of the EMPLOYEES and DEPARTMENTS tables.The following SQL statement was ex
Posted: Wed Jun 07, 2023 6:11 am
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 Exhibi 1 (197.44 KiB) Viewed 158 times
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