IBM C2090-318 Exam Practice Test Instant Access

Question 1

In which phase of SMP/E processing is the DB2 software installed into the target libraries?

AAPPLY

BACCEPT

CRECEIVE

DAPPLY CHECK

Answer : B

Question 2

With which authority can you create, display, activate, or inactivate DB2 audit policies?

ASYSADM

BSYSOPR

CSYSCTRL

DSECADM

Answer : C

Question 3

When must the IRLM address space be active?

ADuring start of DB2

BAfter startup of DB2

CAt the first lock request

DAt the first concurrent lock situation

Answer : D

Question 4

One DB2 catalog page set is corrupt and needs to be recovered to current. Which of the following is TRUE?

AOnly the corrupt page set needs to be recovered

BThe catalog always needs to be recovered as a whole in a certain order

CThe catalog and directory always needs to be recovered as a whole in a certain order

DThe corrupt page set, and all of the page sets that are required prior to this, must be recovered in a certain order

Answer : B

Question 5

At what point in the upgrade process is the catalog migrated to DB2 12?

ACompletion of DSNTIJTC job

BAt the completion of CATMAI NT in function level 500

CAfter issuing command -ACTIVATE FUNCTION LEVEL (V12R1M100)

DAfter issuing command -ACTIVATE FUNCTION LEVEL (V12R1M500)

Answer : A

Question 6

Which subsystem parameter specifies the action that DB2 takes when a problem occurs with the resource limit specification table during execution of a local, static SQL statement?

ARLFERR

BRLFERRD

CRLFERRSTC

DRLFERRDSTC

Answer : D

Question 7

Considering the following command:

-STOP DDF MODE(SUSPEND)

Which of the following, pertaining to DDF connections in a two-way data sharing environment, is TRUE?

AIt suspends DDF threads by preventing the outbound DDF work

BIt stops the DDF on the current member of the data sharing group if DDF has already been started

CIt stops the DDF on all the members of the data sharing group where DDF has already been started

DIt terminates currently executing distributed threads on the current member of the data sharing group

Answer : A

IBM C2090-318 DB2 12 System Administrator for z/OS Exam Practice Test