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

IBM C2090-312 Dumps

Page: 1 / 3
Total 67 questions

IBM DB2 11 DBA for z/OS Questions and Answers

Question 1

What keyword establishes the maximum partition size of a partition-by-growth universal table space?

Options:

A.

PART

B.

DSSIZE

C.

SEGSIZE

D.

MAXPARTITIONS

Question 2

Which technique can be utilized for the reporting of real-time statistics?

Options:

A.

Call stored procedure SYSPROC.DSNACCOX.

B.

Call stored procedure SYSPROC.ADMINJNFOJHOST.

C.

Query the SYSI BM.SYSTABSTATS system catalog table.

D.

Query the SYSIBM.SYSTABLES_PROFILES system catalog table.

Question 3

What is the minimum buffer pool page size for a compressed index?

Options:

A.

4K

B.

8K

C.

16K

D.

32K

Question 4

From where does the cross-loader function allow you to load data?

Options:

A.

From an input file including all columns.

B.

From a cursor including LOB columns but not including XML columns.

C.

From a cursor including XML columns but not including LOB columns.

D.

From a cursor including all LOB and XML columns except the ROWID column.

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:

A.

TCPALVER=NO

B.

TCPALVER=YES

C.

TCPALVER=SERVER_SECURE

D.

TCPALVER=SERVERENCRYPT

Question 6

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

Options:

A.

CLASS(2, 7,8)

B.

CLASS(1, 2,3)

C.

CLASS(1, 5,10)

D.

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:

A.

Changes to the BSDS.

B.

RECOVER to CURRENT.

C.

REORG with RBALRSN_CONVERSION EXTENDED.

D.

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:

A.

-SET LOG LOGLOAD(O)

B.

-DISPLAY DB(DB1)SPACENAM(TS1)

C.

RUNSTATS TABLESPACE DB1TS1

D.

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

Question 9

You want to determine which objects of your database DB1 are in LPL. What command should be used?

Options:

A.

-DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(')

B.

-DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(')

C.

-DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(") SCOPE(GROUP)

D.

-DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(') SCOPE(GROUP)

Question 10

Which statement is true?

Options:

A.

Unicode and EBCDIC have a different collating sequence.

B.

The collating sequence for ASCII and EBCDIC is identical.

C.

The collating sequence for Unicode and EBCDIC is identical.

D.

If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation.

Page: 1 / 3
Total 67 questions