Download DB2 11 System Administrator for z-OS.C2090-317.TestBells.2018-06-02.35q.vcex

ProfExam Suite - Black Friday
Vendor: IBM
Exam Code: C2090-317
Exam Name: DB2 11 System Administrator for z/OS
Date: Jun 02, 2018
File Size: 23 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Which utility can be used to reset the copy-pending status?
  1. REPAIR
  2. DSNJU003
  3. DSN1COPY
  4. COPYTOCOPY
Correct answer: A
Explanation:
Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/db2z_resetindexspacestatus.dita
Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/db2z_resetindexspacestatus.dita
Question 2
What will occur if the parameter PAGE PROTECT is set to YES?
  1. MSTR log buffers (OUTBUFF) will be placed in page-protected storage.
  2. IRLM is to load its common storage modules into page-protected storage.
  3. DIST buffers related to TCPIP connectivity are loaded into page-protected storage.
  4. DBM1 pages belonging to a buffer pool defined with PGFIX(YES) will be placed in page-protected
Correct answer: D
Question 3
The ALTER BUFFERPOOL command specifying the AUTOSIZE(YES) option enables DB2 to use WLM services to fine tune the buffer pools. 
What is the result of issuing this ALTER?
  1. The immediate write threshold can be increased by 25%.
  2. A pool size can be increased by up to 25% over original pool size.
  3. The pool size can be increased in 25% increments base on sequential read hit ratio.
  4. Depending on the type of I/O performed, pool size can be increased or decreased.
Correct answer: B
Explanation:
Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.perf/src/tpc/db2z_enableautobpsize.dita
Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.perf/src/tpc/db2z_enableautobpsize.dita
Question 4
Which method can be used to set the DB2 client information (workstation name, application name..) from a JDBC application using a type 4 connection?
  1. Using the java.sql.Connection.setClientlnfo method
  2. Using the SET_CLIENT_ID option during RRS SIGNON
  3. Using the SQL SET statement (eg. SET CURRENT CLIENT J/VRKSTNNAME = 'MYWS*)
  4. Setting up a profile using the SPECIAL_REGISTER attribute in SYSIBM.DSN PROFILE ATTRIBUTES table
Correct answer: C
Question 5
Which statement regarding migration from DB2 10 for z/OS to DB2 11 for z/OS is true?
  1. All packages must be rebound with application compatibility set to V10R1.
  2. The DB2 catalog and directory must be changed to reside on SMS managed DASD.
  3. All packages last bound prior to DB2 9 for z/OS must be rebound in DB2 10 or DB2 11.
  4. The size of the DB2 bootstrap datasets must be increased to accommodate a larger LRSN and RBA length.
Correct answer: A
Question 6
Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?
  1. SYSOPR
  2. SYSADM
  3. SECADM
  4. SQLADM
Correct answer: C
Explanation:
Reference: http://editorial.mcpressonline.com/web/mcpdf.nsf/wdocs/5127/$FILE/5127_EXP.pdf (page 9)
Reference: http://editorial.mcpressonline.com/web/mcpdf.nsf/wdocs/5127/$FILE/5127_EXP.pdf (page 9)
Question 7
A given buffer pool is to be used for sequentially accessed pages only. 
Setting which buffer pool attribute to 0 (zero) will disable parallel processing operations in this buffer pool?
  1. DWQT
  2. VDWQT
  3. VPSEQT
  4. VPPSEQT
Correct answer: D
Explanation:
Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc/db2z_cmd_alterbufferpool.dita (vppseqt)
Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc/db2z_cmd_alterbufferpool.dita (vppseqt)
Question 8
In order to guarantee complete security for your DB2 subsystem, which statement is correct?
  1. BSDS and catalog VSAM data sets should always be protected by the SYSADM authority.
  2. BSDS and catalog VSAM data sets should always be protected by the MSTR address space.
  3. BSDS and catalog VSAM data sets should always be protected by an external security profile.
  4. BSDS and catalog VSAM data sets should always be protected by the BSDS system privilege
Correct answer: C
Question 9
Which trace can be helpful in determining the resources involved with locking (i.e. deadlocks, timeouts) at a subsystem level?
  1. Statistics trace class 1
  2. Statistics trace class 3
  3. Accounting trace class 1
  4. Accounting trace class 3
Correct answer: B
Question 10
How can conditional restarts affect sequence objects?
  1. Gaps may exist.
  2. Duplicate entries will be deleted.
  3. All values will be reset beginning from 1.
  4. All values will be reset beginning from 0.
Correct answer: A
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!