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

出題：1

Which of the following migration steps is optional?

A. Define DB2 12 to z/OS

B. Define DB2 initialization parameters: DSNTIJUZ

C. Verify the integrity of the DB2 catalog and directory

D. Tailor the DB2 catalog

正解：C 解答を投票する

出題：2

Which subsystem parameter sets the maximum number of concurrent inbound DDF connections that are to be allowed?

A. MAXDBAT

B. MAXKEEPD

C. CONDBAT

D. CTHREAD

正解：B 解答を投票する

出題：3

Which of the following is an advantage of role-based security?

A. Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in time

B. Roles are used to provide a more flexible technique than security group definitions or userids in assigning and controlling authorization

C. If you DROP a role that owns objects, those objects will also be dropped

D. If a role creates an object, a user requires no additional privileges to access the object if the access uses that role as the object owner in the SQL statement

正解：C 解答を投票する

出題：4

The -DISPLAY THREAD(') TYPE(PROC) command can be used to display information about which of the following?

A. Threads executing stored procedures and user-defined functions

B. The subset of system agent threads

C. Threads executing under batch jobs

D. All threads that are actively being processed by DB2

正解：D 解答を投票する

出題：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

DB2A and DB2B are in the same data sharing group on separate LPARs There are two coupling facilities CF01 and CF02. CF01 contains the Lock and SCA structures and CF02 contains the GBP structures. The group buffer pools are not duplexed. The structures can reside on either CF01 or CF02 as specified in the CRFM policy PREFLIST and AUTOREC is set to YES. CF02 fails and DB2A or DB2B can no longer connect to it. Once they are able to reconnect, what action is necessary in order to minimize loss of data availability?

A. Stop members DB2A and DB2B and initiate a group restart

B. No action is needed. Each member performs automatic GRECP recovery

C. No action is needed. The GBP structures are automatically rebuilt in CF02

D. Manually rebuild the GBP structures on CF01

正解：D 解答を投票する

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