Ucertify offers free demo for C2090-612 exam. "DB2 10 DBA for z/OS", also known as C2090-612 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-612 exam, will help you answer those questions. The C2090-612 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-612 exams and revised by experts!
♥♥ 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. 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:
Q12. When is changing an index from non-clustering to clustering NOT allowed?
A. If the table space is defined as member cluster.
B. If the data is not ordered by the new clustering index.
C. If the new clustering index is for a table that uses hash organization.
D. If the new clustering index OBID is greater than the old clustering index OBID.
Answer: C
Explanation:
Q13. DB2 10 is in enabling-new-function mode* after migrating from Version 8, which statement is correct?
A. The DB2 subsystem was at some point in in NFM.
B. The DB2 subsystem can still fall back to DB2 Version 8.
C. Coexistence is allowed with a DB2 9 data sharing group member.
D. The asterisk (*) indicates objects created in NFM can no longer be accessed.
Answer: A
Explanation:
Q14. When converting a multiple table segmented table space to partition-by-growth table spaces, which statement is correct?
A. DSMAX may have to be increased.
B. Storage requirements for EDMDBDC will decrease.
C. Storage requirements for some applications will increase.
D. The dynamic statement cache should be increased to handle the additional SQL statements.
Answer: A
Explanation:
Q15. Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?
A. Copy the index.
B. REBUILD the index.
C. Compress the tablespace.
D. ALTER the index to use a page size larger than 4K.
Answer: D
Explanation:
Q16. What must be done in order to audit read access to a table?
A. AUDIT ALL must be set on the table and an audit trace must be started.
B. An EDITPROC must be defined on the table and an audit trace must be started.
C. DATA CAPTURE CHANGES must be set on the table and the DB2 log must be captured.
D. A security label column should be defined on the table within a trusted context.
Answer: A
Explanation:
Q17. A table space is in AREO*. What does this status mean?
A. A full image copy of the table space must be taken.
B. The table space should be reorganized for optimal performance.
C. A START command must be issued to remove it from the pending status.
D. The table space must be reorganized to materialize all pending changes.
Answer: B
Explanation:
Q18. Which DB2 trace has potentially the highest level of overhead, and should typically be run in specific situations and only for short durations?
A. The DB2 audit trace.
B. The DB2 statistics trace.
C. The DB2 accounting trace.
D. The DB2 performance trace.
Answer: D
Explanation:
Q19. Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?
A. CHECK LOB
B. CHECK INDEX
C. DSN1COPY
D. DSN1CHKR
Answer: D
Explanation:
Q20. What is the purpose of the following query? SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME, TP.TSNAME FROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAME AND TP.TSNAME = TS.NAME);
A. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.
B. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.
C. It identifies which table spaces have missing related rows in SYSIBM.SYSTABLEPART.
D. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.
Answer: C
Explanation: