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

  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

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
Question # 9

Which global variables statement is true?

A.

A global variable is a synonym for special registers.

B.

Like for special registers, the access to global variables cannot be granted or revoked.

C.

A global variable is a created DB2 object, which can be instantiated and used by applications.

D.

Global variables can only be used in native SQL stored procedures and user-defined functions.

Full Access
Question # 10

Which DB2 Client command can be used to identify the Client's version?

A.

db2fm

B.

db2look

C.

db2level

D.

db2ldcfg

Full Access

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