Latest C100DBA Practice Tests with Actual Questions

Get Complete pool of questions with Premium PDF and Test Engine

Exam Code : C100DBA
Exam Name : MongoDB Certified DBA Associate
Vendor Name : "MongoDB"







C2090-317 Dumps

C2090-317 Braindumps C2090-317 Real Questions C2090-317 Practice Test C2090-317 Actual Questions


killexams.com


IBM


C2090-317


DB2 11 System Administrator for z/OS


https://killexams.com/pass4sure/exam-detail/C2090-317



Question: 51

A DDF thread with a token of 56 needs to be cancelled but due to a very tight processing loop in the thread, a regular cancel thread command might not work. What action(s) would provide the best chance to initially attempt to cancel this thread?


  1. -CANCEL THREAD(56)

  2. -CANCEL DDF THREAD(56) FORCE

  3. -CANCEL THREAD(56)NOBACKOUT

  4. -CANCEL DDF THREAD(56)




Answer: B


Reference:

http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc/ db2z_cmd_stopddf.dita



Question: 52

What is the minimum level of authority needed to use the DETAIL keyword on a - DISPLAY THREAD command?


  1. DBADM

  2. SYSADM

  3. SYSOPR

  4. SYSCTRL




Answer: A



Question: 53

Which information uniquely identifies a distributed thread?


  1. The 'ID' field in the -DISPLAY THREAD output.

  2. The 'REG' field in the -DISPLAY THREAD output.

  3. The 'ASID' field in the -DISPLAY THREAD output.

  4. The TOKEN' field in the -DISPLAY THREAD output.




Answer: D


Reference:

http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc/ db2z_cmd_cancelthread.dita(thread (token))



Question: 54

Which copy operation CANNOT be performed by DSN1COPY?


  1. DB2 concurrent copies to DB2 VSAM data sets.

  2. DB2 image copy data sets to DB2 VSAM data sets.

  3. DB2 VSAM data sets to other DB2 VSAM data sets.

  4. DSN1COPY sequential data sets to other sequential data sets.




Answer: A


Reference:

http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/d b2z_utl_dsn1copy.dita



Question: 55

For migration to DB2 11, we must implement the early code (ERLY). What DB2 library contains the early code for DB2?


  1. prefix.SDSNLINK

  2. prefix.SDSNEXIT

  3. prefix.SDSNLOD2

  4. prefix.SDSNLOAD




Answer: A


Reference:

http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.inst/src/tpc/db 2z_chooselinklistopts.dita



Question: 56

The statement cache table, DSN_STATEMENT_CACHE_TABLE. contains information about the SQL statements in the statement cache. Which SQL statement will NOT capture information from the DB2 dynamic statement cache into this table?


  1. EXPLAIN STMTCACHE;

  2. EXPLAIN STMTCACHE ALL;

  3. EXPLAIN STMTCACHE STMTID integer;

  4. EXPLAIN STMTCACHE STMTTOKEN string;




Answer: A



Question: 57

A z/OS Workload Manager (WLM) application environment must be created to enable which functionality in DB2?


  1. Global dynamic SQL caching in the EDM pool

  2. Service class assignments for dispatchable work in DB2

  3. zllP redirect processing for enclave SRB workloads which are zllP redirect eligible

  4. DB2 supplied routine SYSPROC.ADMIN_INFO_SYSPARM. which lists the settings of subsystem parameters




Answer: A



Question: 58

Which statement about the castout process in data sharing is true?


  1. The castout process is initiated by the coupling facility.

  2. The castout process is performed using BPO of the less active member of the group.

  3. The castout process is performed by the first member to express write interest in the data set.

  4. The castout process is performed using a private buffer pool in the first member to join the group.




Answer: C



Question: 59

What utility can benefit from the additional zllP (IBM System z Integrated Information Processor) enablement inDB2 11?


  1. COPY

  2. RUNSTATS

  3. CHECK INDEX

  4. MODIFY STATISTICS



Answer: B



Question: 60

Which z/OS or DB2 component is required for stored procedures that run in a WLM- established address space?


  1. Call attachment facility

  2. TSO attachment facility

  3. Distributed data facility

  4. Resource recovery services




Answer: A