C2090-612 Online Practice Questions and Answers

When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?

A. List prefetch

B. Dynamic prefetch

C. Sequential prefetch

D. Skip sequential prefetch

Which attribute(s) determine the absolute maximum number of partitions for a partition-by- growth table space?

A. MAXPARTITIONS

B. MAXPARTITIONS, DSSIZE

C. MAXPARTITIONS, page size

D. MAXPARTITIONS, DSSIZE, page size

Which ALTER TABLE statement will generate a new table space version?

A. ALTER TABLE ... ADD PARTITION ...

B. ALTER TABLE ... ADD COLUMN COL2 ...

C. ALTER TABLE ... DATA CAPTURE CHANGES ...

D. Altering an already existing VARCHAR column on the table to shorten its maximum length.

A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The addition of COL4 will not support the uniqueness requirement of the index. In order to add this column to the index while still preserving the unique constraint of the first three columns, which option should be taken?

A. Add a new index on COL4.

B. Perform a ALTER INDEX IX1 ADD COLUMN (COL4).

C. Add a new UNIQUE index on COL1, COL2, COL3, COL4.

D. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).

In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?

A. Turn on a monitor trace.

B. Always have a performance trace running.

C. Perform a DISPLAY DATABASE (LOCKS ) command often.

D. Always have statistics classes 1,,3, and 4 and accounting classes 1 and 3 running.

What must be in place for the support of index compression?

A. User defined algorithm.

B. Compression dictionary.

C. Table space compression.

D. Page size larger than 4K.

If security administration is separated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?

A. SYSADM

B. DBADM

C. SECADM

D. INSTALL SYSOPR

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. Copy the index.

B. REBUILD the index.

C. Compress the tablespace.

D. ALTER the index to use a page size larger than 4K.

A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?

A. The data is only stored in the auxiliary table.

B. The data is only stored in the base table.

C. The complete data is stored both in auxiliary and in base table.

D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.

What kind of information is stored in SYSIBM.SYSCOPY?

A. General information needed for recovery.

B. Only information about existing image copies.

C. Information about currently running and stopped copy jobs.

D. Only information about objects which are currently in copy pending.