IBM C2090-320 Exam Questions Instant Access

Question 1

Which types of user-defined data types are supported? (Choose two.)

ACHAR

BARRAY

CNUMERIC

DDISTINCT

ETIMESTAMP

Answer : B, D

Question 2

Which protocol provides applications the ability to connect to a server at another location and execute packages that have been previously bound at that server?

ACLI

BJDBC

CDRDA

DODBC

Answer : D

Question 3

Which catalog table would you query in order to determine the relevant statistics for an index?

ASYSIBM.SYSKEYS

BSYSIBM.SYSFIELDS

CSYSIBM.SYSCOLUMNS

DSYSIBM.SYSINDEXSTATS1

Answer : D

Question 4

COL1 is defined as CHAR(05) and contains CHAR('12345'). Which of the following expressions returns the digits 12345 for further calculation?

AHEX(COL1)

BDEC(COL1)

CPACK(COL1)

DDIGITS(COL1)

Answer : B

Question 5

Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

APAGE

BTABLE

CPARTITION

DTABLESPACE

Answer : C

Question 6

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

AA view

BA temporal table

CA created global temporary table

DA declared global temporary table

Answer : B

Question 7

Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)

AReduced active logs

BReduced storage use

CHigher transaction rates

DReduced lock contention

EIncreased data availability

Answer : C, E

IBM DB2 11 Fundamentals for z/OS C2090-320 Exam Questions