QUESTION: 25

Given the following reporting requirements:

* salary totals of each department
* a grand total of all departments

Which grouping function is designed to handle these requirements?

CUBE
ROLLUP
PARTITION BY
GROUP BY GROUPING SETS

Answer(s): C

Reveal Solution Next Question

QUESTION: 26

Which two are reasons to use a view? (Choose two.)

It enables renaming and formatting of columns.
It simplifies updates to tables that make up the view.
It enables building of large and complex applications.
It simplifies selects from tables that make up the view.

Answer(s): B,D

Reveal Solution Next Question

Given the following table definition:

CREATE TABLE employee (
employee_id INTEGER NOT NULL
, employee_name VARCHAR(50)
, employee_job VARCHAR(50))
PRIMARY INDEX (employee_id);

Which statement is a correct use of a comparison operator?

SELECT * FROM employee WHEREemployee_job IS NULL;
SELECT * FROM employee WHEREemployee_job BETWEEN POSITIONS;
SELECT * FROM employee WHEREemployee_job IS 'governance' OR 'quality';
SELECT * FROM employee WHEREemployee_job IN ANY (maintenance, management, engineer);

Answer(s): D

Reveal Solution Next Question