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:
Q61. What trace class will show deadlock information?
A. Audit class 3.
B. Statistic class 3.
C. Accounting class 1.
D. Performance class 8.
Answer: B
Explanation:
Q62. 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:
Q63. What DB2 command when issued displays what migration mode the catalog is in?
A. DSNC DISPLAY
B. DISPLAY GROUP
C. MODIFY irlmproc,STATUS
D. DISPLAY DATABASE (DSNDB06)
Answer: B
Explanation:
Update C2090-612 book:
Q64. Which stored procedures need to be set up properly in order to register an XML schema?
A. XSR_ADD_SCHEMA
B. XSR_REGISTER and XSR_COMPLETE
C. XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE
D. The commands to register a XML schema do not invoke stored procedures.
Answer: B
Explanation:
Q65. 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:
Q66. 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:
Actual C2090-612 bootcamp:
Q67. What is the appropriate action to maintain data consistency if your page set is in REFP restrictive state?
A. Recover the table space to current.
B. Run the REORG utility with SHRLEVEL NONE.
C. Run a Point In Time RECOVER or the LOAD REPLACE utility.
D. Issue command -START DB(yourdb) SP(yourtbspace) ACCESS(FORCE).
Answer: C
Explanation:
Q68. 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:
Q69. When defining a foreign key on a table, which statement is true?
A. It is not mandatory to have an index on the foreign key columns but it can help to avoid locking problems.
B. There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key checking.
C. It is not mandatory to have an index on the foreign key columns but it can help performance when you insert rows into this table.
D. You must define an index on the foreign key columns where the index columns are the same as the foreign key columns to guarantee uniqueness of the foreign key.
Answer: A
Explanation:
Q70. The performance of BP5 is being evaluated. The Page residency time is being used to see if VPSIZE should be changed. The statistics that are available are VPSIZE of 90,000 and VPSEQT of 15 %. There are 4458 synch I/O per second and 1696 async I/O per second. 6154 total pages read. The system page residency time is 14.6 seconds. Based on a system page residency time of
14.6 seconds, what should be done to increase page residency time?
A. Increase DWQT to 10.
B. Decrease VPSIZE by 45,000 pages.
C. Increase VPSIZE to 180,000 pages.
D. Change the buffer pool to use PGFIX(YES).
Answer: C
Explanation: