IBM Assessment DB2 10 DBA for zOS Set 2

Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?

You want to ALTER a table space specifying MAXPARTITIONS 256. For which table space type does the ALTER fail?

Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?

A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?

When modeling data to provide for a physical design, which of the following defines the data types for the columns in the DB2 physical table?

Which statement about encoding schemes is correct?

Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS);

For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?

Which of the following types of table spaces allow multiple tables?

Which of the following tasks cannot be done via a single ALTER TABLE statement?