Pass C2090-312 Exam Guide

IBM DB2 11 DBA for z/OS Questions and Answers

Question 5

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?

Options:

TCPALVER=NO

TCPALVER=YES

TCPALVER=SERVER_SECURE

TCPALVER=SERVERENCRYPT

Question 6

Which group of DB2 ACCOUNTING trace CLASSES must be started to collect accounting information for PLANS and PACKAGES?

Options:

CLASS(2, 7,8)

CLASS(1, 2,3)

CLASS(1, 5,10)

CLASS(1, 2, 3,7,8)

Question 7

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?

Options:

Changes to the BSDS.

RECOVER to CURRENT.

REORG with RBALRSN_CONVERSION EXTENDED.

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

Question 8

What is the least disruptive way of externalizing real-time statistics for table space DB1TS1?

Options:

-SET LOG LOGLOAD(O)

-DISPLAY DB(DB1)SPACENAM(TS1)

RUNSTATS TABLESPACE DB1TS1

-ACCESS DB(DB1) SPACENAM(TSI) MODE(STATS)

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

IBM DB2 11 DBA for z/OS Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer: