DB2 12 System Administrator for z/OS (C2090-318) Free Practice Test

Question 1

Which of the following can be accomplished by altering a table to use column access control?

A. Modify the values returned for table columns based on column masking definitions

B. Pre-materialize a view with the changed values provided by the column mask

C. Restrict the access to specific rows for all or some users

D. Hide column definitions from the DB2 catalog table SYSIBM.SYSCOLUMNS

Correct Answer: A

Question 2

When using a persistent thread bound with RELEASE(DEALLOCATE), which subsystem parameter setting will permit a REBIND PACKAGE at a COMMIT or ROLLBACK in this thread?

A. BINDNV=BIND

B. PKGREL COMMIT=YES

C. APPLCOMPAT=YES

D. ABIND=COEXIST

Correct Answer: B

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

Question 3

Which of the following subsystem parameters is only applicable in a data sharing environment?

A. DSMAX

B. RETLWAIT

C. TWOACTV

D. REFSHAGE

Correct Answer: B

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

Question 4

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

A. RECEIVE

B. APPLY

C. ACCEPT

D. APPLY CHECK

Correct Answer: B

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

Question 5

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

A. SYSCTRL

B. SECADM

C. SYSOPR

D. SYSADM

Correct Answer: B

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

Question 6

In any disaster recovery scenario, a direct relationship exists between the frequency at which image copies are taken and sent to the recovery site and which of the following?

A. The total number of incremental image copies made

B. Time spent rebuilding indexes at disaster site

C. The ability to perform a RESTORE SYSTEM

D. The amount of data that could potentially be lost

Correct Answer: D

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

Welcome to TestSimulate

IBM DB2 12 System Administrator for z/OS (C2090-318) Free Practice Test