C2090-320 Online Practice Questions and Answers

Which types of user-defined data types are supported? (Choose two.)

A. CHAR

B. ARRAY

C. NUMERIC

D. DISTINCT

E. TIMESTAMP

You want to limit the access of a table to allow users to only see certain columns and/or rows. Which of the following options CANNOT be used to accomplish this?

A. A view

B. Multilevel security

C. An MQT (Materialized Query Table) D. A combination of row permissions and column masks

A clone table can only be created in which of the following?

A. A simple table space

B. A universal table space

C. An auxiliary table space

D. A classic segmented table space

Which of the following are valid objects created using DDL? (Choose two.)

A. PLAN

B. PACKAGE

C. DATABASE

D. SEQUENCE

E. USAGE LISTS

Which of the following effectively and efficiently manages priorities of a mixed workload as a result of its tight integration with DB2 for z/OS?

A. Data Facility Storage Management

B. z/OS Parallel Sysplex Configuration

C. Workload Manager

D. z Systems Processor Resource

Which of the following table space types does NOT support the use of REORG TABLESPACE SHRLEVEL (NONE)?

A. LOB

B. Simple

C. Partition-by-range

D. Partition-by-growth

Which of the following is NOT a valid lock size in DB2?

A. Table

B. Partition

C. Database

D. Table space

Which SQL statement will retrieve the department number (WORKDEPT) and the highest salary (SALARY) for each department in a table named EMPLOYEE and arrange the result set in ascending order by department?

A. SELECT workdept, salary FROM employee GROUP BY workdept ORDER BY workdept;

B. SELECT workdept, MAX(salary) FROM employee ORDER BY workdept GROUP BY 2;

C. SELECT workdept, MAX(salary) FROM employee ORDER BY workdept;

D. SELECT workdept, MAX(salary) FROM employee GROUP BY workdept ORDER BY 1;