Tested of C2090-612 free practice exam materials and ebook for IBM certification for customers, Real Success Guaranteed with Updated C2090-612 pdf dumps vce Materials. 100% PASS DB2 10 DBA for z/OS exam Today!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-612 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-612 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-612-exam-dumps.html
Q11. A single table should allow for up to 100 Terabytes of application data. How do you design your table space?
A. A segmented compressed table space, BUFFERPOOL BP0.
B. A LOB table space with DSSIZE 64GB, BUFFERPOOL BP8K0.
C. A table space with NUMPARTS 1024, DSSIZE 64G, BUFFERPOOL BP16K0.
D. A table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K.
Answer: D
Explanation:
Q12. Which trace gives information about frequent log space shortages?
A. Audit trace class(8)
B. Statistics trace class(3)
C. Accounting trace class(10)
D. Performance trace class(4)
Answer: B
Explanation:
Q13. Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS);
A. The index must be partitioned.
B. The index must use page size > 4K.
C. The index must be defined as UNIQUE.
D. The index must be defined as CLUSTER.
Answer: C
Explanation:
Q14. Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
A. Does not apply to threads that were defined with RELEASE(COMMIT).
B. Does not apply to threads that were defined with RELEASE(DEALLOCATE).
C. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next COMMIT point.
D. Applies to RELEASE(COMMIT) at the next COMMIT point and to RELEASE(DEALLOCATE) at thread end.
Answer: C
Explanation:
Q15. Which statement is true about table check constraints?
A. Only one constraint per column is allowed.
B. The LOAD utility cannot enforce the constraint.
C. A constraint placed on a table does not apply to a view defined on the table.
D. A row meets the requirement of the constraint if the condition evaluates to true or unknown.
Answer: D
Q16. The following DDL statements are executed to create the following objects: CREATE TABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1 INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEX USER1.IX1 ON USER1.TB1 ( COL2 ) BUFFERPOOL BP0 COPY YES; Next, the following ALTER statements are done (in order): 1) ALTER TABLESPACE DB1.TS1 BUFFERPOOL BP8K0 MAXPARTITIONS 20; 2) ALTER TABLESPACE DB1.TS1 SEGSIZE 64; 3) ALTER INDEX USER1.IX1 BUFFERPOOL BP16K0; Which of the following will materialize all of the changes with the least amount of work?
A. Nothing needs to be done.
B. REORG INDEX USER1.IX1 SHRLEVEL CHANGE
C. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE
D. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE REORG INDEX USER1.IX1 SHRLEVEL CHANGE
Answer: C
Explanation:
Q17. For monitoring space growth over time, which statistics should NOT be considered?
A. SYSIBM.SYSTABLEPART_HIST CARDF, SPACEF SYSIBM.SYSINDEXPART_HIST CARDF, SPACEF
B. SYSIBM.SYSTABLEPART CARDF, SPACEF SYSIBM.SYSINDEXPART CARDF, SPACEF
C. SYSIBM.SYSTABLESPACE DSSIZE, AVGROWLEN SYSIBM.SYSINDEXES PIECESIZE, AVGKEYLEN
D. SYSIBM.SYSTABLESPACESTATS SPACE SYSIBM.SYSINDEXSPACESTATS SPACE
Answer: C
Explanation:
Q18. What WLM action will establish performance objectives for DDF threads and their related address space?
A. Insure the NUMTCB is set to a value greater than 10.
B. Specify DDF for the value of APPLENV to the name of the WLM environment.
C. Execute the WLM_REFRESH stored procedure for the DDF application environment.
D. Create a WLM service definition that assigns service classes to the DDF threads.
Answer: D
Explanation:
Q19. In using plan stability, what storage space requirement should be of carefully monitored?
A. MINSTOR
B. DSNDB07
C. DSNDB01.SPT01
D. DSN_STATEMNT_TABLE
Answer: C
Explanation:
Q20. If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?
A. Nothing because DB2 will control the values.
B. A unique index must be defined on the ROWID column.
C. An identity column must also be created to control uniqueness.
D. Extra space must be allocated for an overflow area in the table space.
Answer: B