DB2 10.1 Fundamentals: C2090-610

Which product is used to customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system?

A. pureScale

B. Workload manager

C. Data partitioning feature

D. Self-tuning memory manager

Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?

A. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id = sales.emp_id

B. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON sales.emp_id = employees.id

C. SELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees ON employees.id = sales.emp_id

D. SELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees ON employees.id = sales.emp_id

Which is NOT a valid reason for creating an index?

A. To allow queries to run more efficiently.

B. To enforce constraints such as uniqueness on index keys.

C. To order the columns of a table in ascending or descending sequence according to values in a row.

D. To order the rows of a table in ascending or descending sequence according to the values in a column.