Which two statements are true regarding the output?

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.)

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 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



Leave a Reply 0

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