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 necessary in order to enable optimization hints? 

A. ASYSIBM.PLAN_TABLEtable. 

B. INSERT authority on SYSIBM.SYSQUERY table. 

C. A required index on the PLAN_TABLE used for optimization hints. 

D. ADSN USERQUERY TABLE table under the schema in which hints will be created. 

Answer: C 


Q12. Which DB2 Client command can be used to identify the Client's version? 

A. db2fm 

B. db2look 

C. db2level 

D. db2ldcfg 

Answer: C 


Q13. From where does the cross-loader function allow you to load data? 

A. From an input file including all columns. 

B. From a cursor including LOB columns but not including XML columns. 

C. From a cursor including XML columns but not including LOB columns. 

D. From a cursor including all LOB and XML columns except the ROWID column. 

Answer: A 


Q14. What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G? 

A. 1G 

B. 2G 

C. 4G 

D. 8G 

Answer: C 


Q15. Which command populates the EXPLAIN tables but does not create a package? 

A. REBINDCOPY 

B. REBINDEXPLAIN(NO) 

C. REBINDEXPLAIN(YES) 

D. REBIND EXPLAIN(ONLY) 

Answer: D 

Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc/db2z_ bindoptexplain.dita 


Q16. 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 


Q17. 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 


Q18. Which statement is true regarding table-controlled partitioned table spaces without a MAXVALUE specified? 

A. If the partitioning key is ascending, DB2 prevents the INSERT of a row with a null value for the key column. 

B. If the partitioning key is descending, DB2 prevents the INSERT of a row with a null value for the key column. 

C. If the partitioning key is ascending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the first partition. 

D. If the partitioning key is descending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the last partition. 

Answer: C 


Q19. Which is NOT a valid privilege/authority for executing CREATE TYPE (array)? 

A. SYSADM 

B. SYSOPR 

C. SYSCTRL 

D. CREATEIN on the schema 

Answer: A 


Q20. When performing several inserts into a table defined with an identity column, which attribute could be ALTERed to help with the performance? 

A. RESET 

B. CACHE 

C. MAXVALUE 

D. INCREMENT 

Answer: D