IBM DB2 11 DBA for z/OS (C2090-312) Free Practice Test

Question 1

DB2 will not allow certain processing to occur when the soft limit of RBA TFF800000000'x is reached and an object's RBA remains in basic 6-byte format.
What processing is NEVER allowed?

A. REORGwith RBALRSN_CONVERSION EXTENDED.

B. SQL update activities (INSERT. UPDATE, DELETE, MERGE).

C. RECOVER to CURRENT.

D. Changes to the BSDS.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

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

A. 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.

B. If the partitioning key is ascending, DB2 prevents the INSERT of a row with a null value for the key column.

C. If the partitioning key is descending, DB2 prevents the INSERT of a row with a null value for the key column.

D. 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.

Correct Answer: A

Question 3

What is a general recommendation for when to rebind?

A. After a subsystem restart.

B. Before maintenance is applied.

C. After a backup is taken.

D. After a major change in data volume.

Correct Answer: A

Question 4

In order to use a literal replacement for a dynamic SQL caching statement what must be true about the statement?

A. It must include more than one literal.

B. It cannot have both literals and parameter markers.

C. It cannot be a join.

D. The authids do not have to match.

Correct Answer: B

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 DSN1PRNT job output of the header page.

B. In the z/OS system log (SYSLOG), as all commands including DB2 commands are written to the z/OS system log.

C. In the DB2 recovery log as all DB2 commands are written to the DB2 recovery log.

D. In the DB2 MSTR address space joblog as all DB2 commands are shown there.

Correct Answer: D

Question 6

You are trying to reduce the transaction CPU cost by using KEEPDYNAMIC(YES). Which subsystem parameter would you increase to improve Local Dynamic Cache Hit Ratio and reduce the number of short prepares?

A. MAXRBLK

B. MAXTEMPS

C. MAXKEEPD

D. CONTSTOR

Correct Answer: C

Question 7

The TCP/IP Already Verified (TCPALVER) DB2 system parameter controls whether DB2 accepts a TCP/IP connection requests. Which statement is NOT a valid value?

A. TCPALVER=SERVER_SECURE

B. TCPALVER=YES

C. TCPALVER=SERVERENCRYPT

D. TCPALVER=NO

Correct Answer: B

Welcome to TestSimulate

IBM DB2 11 DBA for z/OS (C2090-312) Free Practice Test