It is impossible to pass IBM C2090-612 exam without any help in the short term. Come to Ucertify soon and find the most advanced, correct and guaranteed IBM C2090-612 practice questions. You will get a surprising result by our Regenerate DB2 10 DBA for z/OS practice guides.
♥♥ 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
Q1. Your current backup strategy is to run COPY SHRLEVEL CHANGE for all your table spaces each night. You create FULL image copies once a week and INCREMENTAL copies during the rest of the days. After migrating to DB2 10, you plan to create the FULL image copies using FLASHCOPY YES and COPYDDN, that is you create a flash copy image copy (FCIC) and additionally a sequential copy. What happens to the incremental copies that you continue to create on all other days?
A. If DSNZPARM FLASHCOPY_COPY is set to YES, the incremental copies will automatically be incremental FLASHCOPY copies.
B. Nothing special. The only difference is that the FULL copy, which is the basis for the subsequent incremental copies has now been generated from the FCIC.
C. The COPY utilities with FULL NO option will not run. If there are entries in SYSIBM.SYSCOPY that indicate that FCICs exist for a give page set, INCREMENTAL copies cannot be taken anymore.
D. The first image copy utility execution after the FULL FCIC and sequential copy created from the
FCIC will end up as FULL copy although you specify the FULL NO statement on the COPY utility control statement.
Answer: D
Explanation:
Q2. The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?
A. The encoding scheme of the table is EBCDIC.
B. The encoding scheme of the table is UNICODE.
C. This could never happen, this is an error and must be reported.
D. This is expected behavior and independent of the encoding scheme.
Answer: B
Explanation:
Q3. 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
Q4. Which option allows the UNLOAD utility to unload LOBs into output files together with non-LOB data?
A. DELIMITED
B. SPANNED YES
C. DSNTYPE HFS on the TEMPLATE
D. DSNTYPE LIBRARY or PDS on the TEMPLATE
Answer: B
Explanation:
Q5. 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
Q6. Which of the following tasks cannot be done via a single ALTER TABLE statement?
A. Add a new partition to the table space.
B. Change the VALIDPROC attribute of the table.
C. Change a table check constraint on the table.
D. Change the DATA CAPTURE attribute of the table.
Answer: C
Explanation:
Q7. What is the DSNZPARM that determines the maximum amount of temporary storage in the work file data base for a single user at any given time?
A. MAXRBLK
B. MAXDBAT
C. MAXKEEPD
D. MAXTEMPS
Answer: D
Explanation:
Q8. What IBM provided stored procedure will access DB2 real time statistics tables?
A. DSNAEXP
B. DSNAIMS
C. DSNACCOX
D. DSNLEUSR
Answer: C
Explanation:
Q9. 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:
Q10. What is the maximum levels of backup that DB2 plan stability can support?
A. 1
B. 2
C. 3
D. 4 Answer: C
Explanation: