Exam Code: C2090-317 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 11 System Administrator for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-317 Exam.
2021 Apr C2090-317 Study Guide Questions:
Q11. How can conditional restarts affect sequence objects?
A. Gaps may exist.
B. Duplicate entries will be deleted.
C. All values will be reset beginning from 1.
D. All values will be reset beginning from 0.
Answer: A
Q12. In an environment with a large amount of dynamic SQL, which subsystem parameter should be adjusted to increase the amount of memory available for caching statements in the global dynamic statement cache?
A. EDMPOOL
B. EDMDBDC
C. MAXKEEPD
D. EDMSTMTC
Answer: C
Q13. Which command can be used to adjust the system checkpoint frequency?
A. -SET LOG
B. -SET ARCHIVE
C. -ARCHIVE LOG
D. -RECOVER BSDS
Answer: A
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc /db2z_cmd_setlog.dita
Up to the immediate present C2090-317 exam question:
Q14. A z/OS Workload Manager (WLM) application environment must be created to enable which functionality in DB2?
A. Global dynamic SQL caching in the EDM pool
B. Service class assignments for dispatchable work in DB2
C. zllP redirect processing for enclave SRB workloads which are zllP redirect eligible
D. DB2 supplied routine SYSPROC.ADMIN_INFO_SYSPARM. which lists the settings of subsystem parameters
Answer: A
Q15. Which trace can be helpful in determining the resources involved with locking (i.e. deadlocks, timeouts) at a subsystem level?
A. Statistics trace class 1
B. Statistics trace class 3
C. Accounting trace class 1
D. Accounting trace class 3
Answer: B
Q16. Which combination of subsystem parameter values will enable connection pooling for idle distributed database access threads?
A. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT = MAXDBAT.
B. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT < MAXDBAT.
C. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT > MAXDBAT.
D. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT >MAXDBAT.
Answer: C
Explanation:Reference:http://db2onlinehandbook.com/?p=1263
Realistic C2090-317 testing material:
Q17. You wish to enable automatic clean-up of committed pseudo-deleted index entries for all indexes in the DB2 subsystem. You have verified that system table SYSIBM.SYSINDEXCLEANUP has no rows.
Without taking any other action, which action will accomplish this?
A. Set subsystem parameter INDEX_CLEANUP_THREADS to 10.
B. Set subsystem parameter INDEX_CLEANUP_THREADS to YES.
C. Issue an ALTER INDEX statement against all indexes with ERASE YES.
D. Issue an ALTER INDEX statement against all indexes with FREEPAGE 0.
Answer: A
Explanation:Reference:http://www.gsebelux.com/system/files/GSE%20DB2%20DB2%2011%20Availabi lity%20endhancements.pdf(slide 20)
Q18. You wish to set the threshold at which data in the class castout queue is cast out to disk for group buffer pool GBP10. You want the threshold to be 1000 pages.
Which parameter setting in the command -ALTER GBPOOL(GBP10) will accomplish this?
A. GBPOOLT(10)
B. CLASST(0.1000)
C. CLASST(10.1000)
D. GBPCHKPT(1000)
Answer: A
Q19. For migration to DB2 11, we must implement the early code (ERLY).
What DB2 library contains the early code for DB2?
A. prefix.SDSNLINK
B. prefix.SDSNEXIT
C. prefix.SDSNLOD2
D. prefix.SDSNLOAD
Answer: A
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.inst/src/tpc/db 2z_chooselinklistopts.dita
Q20. You are facing a severe locking problem with a specific application using plan PLANB. To identify what is going on you need to start a detailed locking trace. However, you want to limit the scope of the trace somewhat to reduce the trace overhead and trace volume. (IFCID 21 traces each lock request and is part of performance trace class 7).
Which is the most appropriate command to use ?
A. -STA TRA(P) CLASS(7) DEST(GTF) PLAN(PLANB)
B. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) PLAN(PLANB)
C. -STATRA(P)CLASS(30) IFCID(21) DEST(GTF) PLAN(PLANB)
D. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) XPLAN(PLANB')
Answer: B