Free TE0-122 Exam Braindumps (page: 8)

Page 7 of 38

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?

  1. CUBE
  2. ROLLUP
  3. PARTITION BY
  4. GROUP BY GROUPING SETS

Answer(s): C



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

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

Answer(s): B,D



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?

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

Answer(s): D



Which two are compatible with DISTINCT in a SELECT statement? (Choose two.)

  1. WITH clause
  2. TOP N operator
  3. recursive queries
  4. CLOB cast as VARCHAR
  5. BLOB cast as VARBYTE

Answer(s): C,D






Post your Comments and Discuss TeraData TE0-122 exam with other Community members:

TE0-122 Discussions & Posts