Exam Code: C2090-312 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM DB2 11 DBA for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-312 Exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-312 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-312 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-312-exam-dumps.html
Q11. What is required before you begin your installation of DB2 11?
A. Data sets for catalog and directory tables must be user-managed.
B. Data sets for only the catalog tables must be SMS-managed and include a data class for allocating the data sets in extended format.
C. Data sets for only the directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.
D. Data sets for catalog and directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.
Answer: A
Q12. The degree of parallelism can vary for the REBUILD INDEX utility.
What action should be taken to limit the use of real memory using the REBUILD INDEX utility?
A. Increase the value of the PARALLEL option.
B. Decrease the value of the PARALLEL option.
C. Increase the value in the CURRENT DEGREE special register.
D. Decrease the value in the CURRENT DEGREE special register.
Answer: A
Q13. Given the following output:
DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS -DSNV402I _DB2D ACTIVE THREADS -NAME ST A REQ ID AUTHID PLAN ASID TOKEN DB2CALL T 17039 BBISS BBISS 00AF 19855 TSO T * 3 KSTTEST KSTTEST 0135 20212 A51OTEST N* 13 CICSTEST 0125 19625 You receive a call that user KSTTEST is holding resources and needs to be canceled.
Which command should be issued?
A. -CANCEL THREAD( 3)
B. -CANCEL THREAD(20212)
C. -CANCEL USER(KSTTEST)
D. User KSTTEST does not hold an active connection, no way he blocks anything.
Answer: A
Q14. You want to determine which objects of your database DB1 are in LPL. What command should be used?
A. -DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(')
B. -DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(')
C. -DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(") SCOPE(GROUP)
D. -DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(') SCOPE(GROUP)
Answer: B
Q15. Which DB2 subsystem parameter limits the number of concurrent active TSO requests?
A. IDBACK
B. IDFORE
C. MAXDBAT
D. CONDBAT
Answer: B
Q16. Which technique can be utilized for the reporting of real-time statistics?
A. Call stored procedure SYSPROC.DSNACCOX.
B. Call stored procedure SYSPROC.ADMINJNFOJHOST.
C. Query the SYSI BM.SYSTABSTATS system catalog table.
D. Query the SYSIBM.SYSTABLES_PROFILES system catalog table.
Answer: D
Q17. You analyze an accounting report. You see a high "NOT ACCOUNTED" time. Which two events can contribute to this high value?
A. CPU wait time.
B. I/O read wait time.
C. Log write wait time.
D. Real storage paging wait time.
E. Execution unit switch wait time.
Answer: C,E
Q18. Which statement is true for data in columns defined with data type XML?
A. Data stored in XML columns cannot be indexed.
B. It is possible to define the XML column with an INLINEJ.ENGTH.
C. You can partially UPDATE, DELETE from, and INSERT into an XML document.
D. If you want to change an existing XML document, you have to replace the whole document in the XML column.
Answer: C
Q19. When would DB2 NOT use list prefetch?
A. Fast log apply operations.
B. Reading leaf pages of a disorganized index.
C. RUNSTATS TABLESPACE without table sampling.
D. Incremental image copies of a table space defined with TRACKMOD YES.
Answer: B
Q20. Which type of stored procedures do NOT require a WLM-managed stored procedure address space?
A. External stored procedures.
B. Native SQL stored procedure.
C. External SQL stored procedures.
D. DB2 supplied stored procedures.
Answer: B