C2090-312 by IBM Valid Free Exam Practice Test

Question 1

Prefetch l/Os are executed under a service request block in which address space?

A. User address space B. IRLM C. MSTR D. DBM1

Correct Answer: D

Question 2

Which statement is true regarding table-controlled partitioned table spaces without a MAXVALUE specified?

A. If the partitioning key is ascending, DB2 prevents the INSERT of a row with a null value for the key column. B. If the partitioning key is descending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the last partition. C. If the partitioning key is ascending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the first partition. D. If the partitioning key is descending, DB2 prevents the INSERT of a row with a null value for the key column.

Correct Answer: C

Question 3

Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?

A. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Local Dynamic Statement Cache. B. The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic Statement Cache. C. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Global Dynamic Statement Cache. D. The PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic Statement Cache.

Correct Answer: C

Question 4

Arrays are based on a built-in data type. On which built-in data type can an array NOT be based?

A. CLOB B. DBCLOB C. XML D. VARBINARY

Correct Answer: C

Question 5

The data of a critical table space seems inconsistent. It is suspected that someone has accidentally issued a DB2 command to start the object with MODE(FORCE).
Where can this be verified?

A. In the z/OS system log (SYSLOG), as all commands including DB2 commands are written to the z/OS system log. B. In the DB2 recovery log as all DB2 commands are written to the DB2 recovery log. C. In the DB2 MSTR address space joblog as all DB2 commands are shown there. D. In the DSN1PRNT job output of the header page.

Correct Answer: C

Question 6

The degree of parallelism can vary for the REBUILD INDEX utility.
What action should be taken to limit the use of real memory using the REBUILD INDEX utility?

A. Increase the value of the PARALLEL option. B. Decrease the value in the CURRENT DEGREE special register. C. Increase the value in the CURRENT DEGREE special register. D. Decrease the value of the PARALLEL option.

Correct Answer: A

Question 7

You analyze an accounting report. You see a high "NOT ACCOUNTED" time. Which two events can contribute to this high value?

A. Log write wait time. B. Real storage paging wait time. C. CPU wait time. D. Execution unit switch wait time. E. I/O read wait time.

Correct Answer: A,D

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