DB2 11 System Administrator for z/OS (C2090-317) Free Practice Test

Question 1

Program Authorization does NOT work in which environment?

A. CICS

B. Programs that run in stored procedure address spaces

C. IMS

D. DSN command processor

Correct Answer: D

Question 2

Which statement is true regarding DB2 definitions for SMF collection?

A. At the minimum, DB2 statistics class 1 trace is required.

B. The SMF subsystem does not have to be active for DB2 to write SMF trace records.

C. SMF collection is not required for DB2.

D. At the minimum. DB2 accounting classes 1.2.3 are required.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Which DB2 system table can limit the amount of resources that can be consumed based on client or IP address of the client?

A. SYSIBM.DSNRLMT01

B. SYSIBM.IPLIST

C. SYSIBM.DSNRLST01

D. SYSIBM.IPNAMES

Correct Answer: A

Question 4

What job will check for changes to DB2 that might impact your migration to Version 11 conversion mode?

A. DSNTIJPM

B. DSNTIJXA

C. DSNTIJIC

D. DSNTIJTC

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

In order to guarantee complete security for your DB2 subsystem, which statement is correct?

A. BSDS and catalog VSAM data sets should always be protected by an external security profile.

B. BSDS and catalog VSAM data sets should always be protected by the BSDS system privilege

C. BSDS and catalog VSAM data sets should always be protected by the SYSADM authority.

D. BSDS and catalog VSAM data sets should always be protected by the MSTR address space.

Correct Answer: A

Question 6

Which utility can be used to reset the copy-pending status?

A. DSNJU003

B. REPAIR

C. COPYTOCOPY

D. DSN1COPY

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate