Proper study guides for Regenerate IBM IBM DB2 11 DBA for z/OS certified begins with IBM C2090-312 preparation products which designed to deliver the Actual C2090-312 questions by making you pass the C2090-312 test at your first time. Try the free C2090-312 demo right now.


♥♥ 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

Q31. You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement: 

ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5; 

What should be your next step? 

A. COPY the table space. 

B. REORG the table space. 

C. REBUILD all of the indexes. 

D. DROP the segmented table space. 

Answer: D 


Q32. As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action? 

A. Issue the ACCESS command with appropriate keywords. 

B. Issue the ARCHIVE command with the appropriate keywords. 

C. Issue the STOP command for the appropriate set of statistics. 

D. Issue the ALTER command with the appropriate memory location. 

Answer: A 


Q33. Which component is NOT shared between DB2 data sharing members? 

A. SCA 

B. IRLM 

C. DB2 catalog 

D. DB2 directory 

Answer: C 


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


Q35. A table space is successfully recovered by using RECOVER TABLESPACE db. ts TOLASTFULLCOPY. This table space is referenced by an index. 

Which statement is true? 

A. The index has now a status of REFP. 

B. The index has now a status of RECP. 

C. The index has now a status of CHKP. 

D. The index has now a status of RBDP. 

Answer: C 


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


Q37. 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) 


Q38. Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the results in a data set or as a result set? 

A. ADMIN_INFO_SQL 

B. ADMIN_JOB_QUERY 

C. ADMIN_INFO_SYSPARM 

D. ADMIN UPDATESYSPARM 

Answer: C 

Reference: 

http://www.redbooks.ibm.com/redbooks/pdfs/sg248151.pdf (page 72, see the table) 


Q39. DB2 will not allow certain processing to occur when the soft limit of RBA TFF800000000'x is reached and an object's RBA remains in basic 6-byte format. 

What processing is NEVER allowed? 

A. Changes to the BSDS. 

B. RECOVER to CURRENT. 

C. REORGwith RBALRSN_CONVERSION EXTENDED. 

D. SQL update activities (INSERT. UPDATE, DELETE, MERGE). 

Answer: C 

Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.admin/src/tpc/db2z_r balrsnlimitsreached.dita