Want to know Examcollection C2090-312 Exam practice test features? Want to lear more about IBM IBM DB2 11 DBA for z/OS certification experience? Study Exact IBM C2090-312 answers to Improve C2090-312 questions at Examcollection. Gat a success with an absolute guarantee to pass IBM C2090-312 (IBM DB2 11 DBA for z/OS) test on your first attempt.


♥♥ 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 subsystem parameter in DDF specifies the maximum number of inactive or new connections queued that can be waiting for a DBAT to process the request? 

A. IDTHTOIN 

B. MAXDBAT 

C. CONDBAT 

D. MAXCONQN 

Answer: D 


Q12. You must be able to process recoveries for DB2 objects to any point in time between now and two weeks ago. 

What is the recommended amount of recovery data needed? 

A. One set of SHRLEVEL(CHANGE) full image copies every two weeks that are kept for at least two weeks. 

B. One set of SHRLEVEL(CHANGE) full image copy at least every week that are kept for at least three weeks as well as the active/archive logs during that time. 

C. One set of SHRLEVEL(CHANGE) full images copies at least every week that are kept for at least two weeks as well as the active/archive logs during that time. 

D. One set of SHRLEVEL(CHANGE) full images copies during week#1 and one set of SHRLEVEL(REFERENCE) incremental images copies during week #2, all are kept for at least two weeks. 

Answer: D 

Reference:http://www.gsebelux.com/system/files/GSE%20backup%20and%20recovery%20%20at %20KBC.pdf(page 10) 


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


Q14. A statement-level access path hint can be applied to which type of SQL statement? 

A. Static SQL statements only. 

B. Dynamic SQL statements only. 

C. Both static and dynamic SQL statements. 

D. Statements included in a CREATE PROCEDURE statement only. 

Answer: B 


Q15. In order to use a literal replacement for a dynamic SQL caching statement what must be true about the statement? 

A. It cannot be a join. 

B. The authids do not have to match. 

C. It must include more than one literal. 

D. It cannot have both literals and parameter markers. 

Answer: D 


Q16. What keyword establishes the maximum partition size of a partition-by-growth universal table space? 

A. PART 

B. DSSIZE 

C. SEGSIZE 

D. MAXPARTITIONS 

Answer: C 


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

A. db2fm 

B. db2look 

C. db2level 

D. db2ldcfg 

Answer: C 


Q18. Which statement is true? 

A. Unicode and EBCDIC have a different collating sequence. 

B. The collating sequence for ASCII and EBCDIC is identical. 

C. The collating sequence for Unicode and EBCDIC is identical. 

D. If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation. 

Answer: A 

Reference:http://www-01.ibm.com/support/knowledgecenter/SS4LQ8_3.1.0/com.ibm.datatools.aqt3.doc/gui/concepts/c_i daa_inconsistencies.html(first bulleted point on the page) 


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


Q20. When we use multilevel-security using a security label column, which sentence is true? 

A. A unique constraint is allowed on a security label column. 

B. A check constraint is not allowed on a security label column. 

C. A referential constraint is not allowed on a security label column. 

D. Multilevel security with row-level checking is enforced when DB2 checks a referential constraint. 

Answer: C