Exam Code: C2090-612 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10 DBA for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-612 Exam.
2021 Apr C2090-612 Study Guide Questions:
Q51. When planning for disaster recovery, which two items are NOT required to send to the remote site? (Choose two.)
A. DB2 archive logs.
B. Image copies of indexes.
C. A copy of your ICF catalog.
D. Image copies of table spaces.
E. Backups of the DB2 catalog and directory.
Answer: B,C
Explanation:
Q52. A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?
A. The data is only stored in the auxiliary table.
B. The data is only stored in the base table.
C. The complete data is stored both in auxiliary and in base table.
D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.
Answer: B
Explanation:
Q53. Altering the DSSIZE is allowed for what type of table space?
A. XML table space.
B. Universal table space.
C. Segmented table space.
D. DSSIZE cannot be altered.
Answer: B
Explanation:
Renewal C2090-612 exam topics:
Q54. The threads initiated by the distributed transactions are no longer active in DB2, however this situation has caused -904 resource unavailable condition for the other executing threads in DB2. Which command could assist in identifying the remote locations from where such threads were triggered?
A. -DISPLAY LOCATION(*) DETAIL
B. -DIS THD(*) TYPE(INDOUBT) LOCATION(*) DETAIL
C. -DIS THD(*) TYPE(INACTIVE) LOCATION(*) DETAIL
D. -DIS THD(*) TYPE(POSTPONED) LOCATION(*) DETAIL
Answer: B
Explanation:
Q55. What would be a reason for altering the clustering index of a table?
A. To increase free space.
B. Because the clustering index has to match the primary index.
C. To choose a clustering index to favor batch sequential processing.
D. To choose a clustering index to promote sequential inserts at the end of the table space.
Answer: C
Explanation:
Q56. What must be in place for the support of index compression?
A. User defined algorithm.
B. Compression dictionary.
C. Table space compression.
D. Page size larger than 4K.
Answer: D
Explanation:
Exact C2090-612 testing engine:
Q57. Which of the following results in improving performance of a load job to load data into an indexed partitioned table space with multiple indexes?
A. LOG YES
B. PREFORMAT
C. SORTKEYS integer
D. convert input data
Answer: C
Explanation:
Q58. For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?
A. Catalog tables
B. Directory tables
C. Auxiliary tables
D. Declared global temporary tables
Answer: A
Explanation:
Q59. During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?
A. RBA
B. LRSN
C. ROWID
D. SYSPITRT
Answer: B
Explanation:
Q60. To monitor the storage used above and below the 2GB bar, what must occur?
A. Start a statistics class 1 trace.
B. Start a monitor class 1 & 2 trace.
C. Start an audit class 3 trace.
D. Start accounting class 7 & 8 traces.
Answer: A