New Year Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

  1. Home
  2. IBM
  3. IBM Information Management
  4. C2090-312 - IBM DB2 11 DBA for z/OS
Note! Following C2090-312 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

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

Go to page:
Question # 4

Which address space should be classified with the highest priority WLM service class?

A.

DIST

B.

IRLM

C.

DBM1

D.

MSTR

Full Access
Question # 5

Which table characteristic is a good attribute for the exploitation of hash access?

A.

At least 20 rows fit on a data page.

B.

DB2 uses range scans to access rows in the table.

C.

The size of individual rows in the table vary greatly.

D.

DB2 uses sequential lookups to access data in the table.

Full Access
Question # 6

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.

Changes to the BSDS.

B.

RECOVER to CURRENT.

C.

REORG with RBALRSN_CONVERSION EXTENDED.

D.

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

Full Access
Question # 7

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

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.

Full Access
Question # 8

A statement-level access path hint can be applied to which type of SQL statement?

A.

Static SQL statements only.

B.

Dynamic SQL statements only.

C.

Both static and dynamic SQL statements.

D.

Statements included in a CREATE PROCEDURE statement only.

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps