C2090-312 Exam - Free IBM Questions and Answers

Question #6 (Topic: )

Which statement about an array data type is true?

A. User-defined data types are allowed in an array. B. An array is a built-in data type and can only be numeric. C. Arrays can be used as direct input to a select-statement predicate. D. Associative arrays can only use INTEGER and VARCHAR data types as indexes.

Answer: D

Question #7 (Topic: )

Index versions are created when certain schema changes are committed. Which schema
change results in a new index version being created?

A. Issue the ALTER INDEX REGENERATE statement. B. Use the ALTER INDEX statement to add a column to an index that was built with DEFINE NO. C. Add a new column to both a table and an index in the same commit operation when the table is in a partition-by-growth table space and the index is built with DEFINE YES. D. When you extend the length of a varying-length character (VARCHAR data type) or varying-length graphic (VARGRAPHIC data type) column that is contained in one or more indexes that are defined with the NOT PADDED option.

Answer: B

Question #8 (Topic: )

A table space is successfully recovered by using RECOVER TABLESPACE db.ts
TOLASTFULLCOPY. This table space is referenced by an index.
Which statement is true?

A. The index has now a status of REFP. B. The index has now a status of RECP. C. The index has now a status of CHKP. D. The index has now a status of RBDP.

Answer: C

Question #9 (Topic: )

Which is NOT a valid value for the KEYWORDS column in the
DSN_PROFILES_ATTRIBUTES table?

A. MONITOR THREAD B. MONITOR IDLE THREADS C. MONITOR CONNECTIONS D. MONITOR ACTIVE THREADS

Answer: B

Question #10 (Topic: )

Which component is NOT shared between DB2 data sharing members?

A. SCA B. IRLM C. DB2 catalog D. DB2 directory

Answer: C

IBM C2090-312 - IBM DB2 11 DBA for z/OS Exam