C1000-078試験無料問題集（62題）「IBM Db2 12 for z/OS Administrator 認定」

出題：1

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. ABIND=COEXIST

B. BINDNV=BIND

C. APPLCOMPAT=YES

D. PKGREL COMMIT=YES

正解：C 解答を投票する

出題：2

Which lEAOPTxx parameter and value determines that processes will be routed from zllP to general processors when the zllP engines have no more capacity?

A. IIPHONORPRIORITY = YES

B. IIPHONORPRIORITY = NO

C. IFAHONORPRIORITY = NO

D. IFAHONORPRIORITY = YES

正解：C 解答を投票する

出題：3

Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?

A. DSNDB06.SYSDDF

B. DSNDB01.SYSSPT01

C. DSNDB01.SYSUTILX

D. DSNDB01.SYSLGRNX

正解：C 解答を投票する

出題：4

Which of the following is TRUE about the SYSCTRL authority?

A. It is designed to allow access to all data directly in DB2

B. It is designed so group privileges cannot be granted to SYSCTRL

C. It is designed to be an administrator in a system with sensitive data

D. It is designed not to be a part of the administrative authorizations

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

In planning to migrate your system to DB2 12. which actions can check for release dependencies and catalog integrity prior to migration?

A. Run job DSNTIJPM when at DB2 12 Function Level V12R1M100

B. Run DSNTIJPM and DSNTESQ at DB2 11 NFM from the DB2 12 target libraries

C. While still at DB2 11 run the job DSNTIJPM from the DB2 11 target libraries

D. Run job DSNTIJPC from the DB2 11 target libraries before migrating to DB2 12

正解：A 解答を投票する

出題：6

The amount of memory taken up by the local dynamic statement cache is extremely high. How can this be reduced?

A. Reduce the value specified for subsystem parameter EDMSTMTC

B. Bind more packages using BIND option KEEPDYNAMIC(YES)

C. Reduce the value specified for subsystem parameter MAXKEEPD

D. Reduce the value specified for subsystem parameter MAX_IN_MEMORY

正解：B 解答を投票する

出題：7

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

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

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

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

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

正解：C 解答を投票する

C1000-078試験無料問題集「IBM Db2 12 for z/OS Administrator 認定」