Proper study guides for Abreast of the times IBM DB2 10 DBA for z/OS certified begins with IBM C2090-612 preparation products which designed to deliver the Guaranteed C2090-612 questions by making you pass the C2090-612 test at your first time. Try the free C2090-612 demo right now.
♥♥ 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
Q71. The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANGE with utilid REORGON. Which statement is NOT true?
A. It shows how many keys are rejected when issued during the SORTBLD phase.
B. It shows the elapsed time of the SWITCH phase when issued during the SWITCH phase.
C. It indicates how many parallel tasks are involved to build indexes when issued during the BUILD phase.
D. It shows an actual and estimated time of how far it has proceeded in the current iterations when issued during the LOG phase.
Answer: A
Explanation:
Q72. When planning for backup/recovery (including disaster recovery), which statement is correct?
A. When you remote copy everything (PPRC, XRC) there is no need to take DB2 image copies anymore.
B. As data is shared in a data sharing group, disaster recovery in a data sharing environment is identical to a non-data sharing environment.
C. System level backups (BACKUP SYSTEM) can be used for both system wide restore on a remote site, as well as the recovery of individual objects locally.
D. When you want to create a consistent backup point, you must use the -SET LOG SUSPEND command to freeze all activity, and then take your backups with whatever technology you prefer.
Answer: C
Explanation:
Q73. A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The addition of COL4 will not support the uniqueness requirement of the index. In order to add this column to the index while still preserving the unique constraint of the first three columns, which option should be taken?
A. Add a new index on COL4.
B. Perform a ALTER INDEX IX1 ADD COLUMN (COL4).
C. Add a new UNIQUE index on COL1, COL2, COL3, COL4.
D. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).
Answer: D
Explanation:
Q74. 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:
Q75. You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized?
A. Audit trace class(4)
B. Monitor trace class(6)
C. Performance trace class(3)
D. Accounting trace class(1,2,3,7,8)
Answer: C
Explanation:
Q76. 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:
Q77. DB2 does not take system checkpoints in which circumstance?
A. During an application rollback.
B. At the end of a successful restart.
C. When switching from one active log data set to another.
D. When a specified number of log records are created or after a specified number of minutes, whichever occurs first.
Answer: A
Explanation:
Q78. In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)
A. Column CLUSTERING in SYSIBM.SYSINDEXES
B. Column LEAFDIST in SYSIBM.SYSINDEXPART
C. Column CLUSTERRATIOF in SYSIBM.SYSINDEXES
D. Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS
E. Columns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART
Answer: A,D
Explanation:
Q79. Which statement about encoding schemes is correct?
A. A view can have columns with different encoding schemes.
B. A table can have columns with different encoding schemes.
C. A table space can have tables with different encoding schemes.
D. All objects in the subsystem must use the same encoding schemes.
Answer: A
Explanation:
Q80. If SEGSIZE 64 and MAXPARTITIONS 10 are specified in a CREATE TABLESPACE statement, what type of table space is created?
A. LOB table space.
B. Segmented table space.
C. Range-partitioned table space.
D. Partition-by-growth table space.
Answer: D