Download of C2090-612 pdf exam materials and answers for IBM certification for IT engineers, Real Success Guaranteed with Updated C2090-612 pdf dumps vce Materials. 100% PASS DB2 10 DBA for z/OS exam Today!
2021 May C2090-612 Study Guide Questions:
Q31. Which of the following types of table spaces allow multiple tables?
A. Segmented
B. LOB table space
C. Partition-by-range
D. Partition-by-growth
Answer: A
Explanation:
Q32. In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used?
A. GBP32
B. SCA
C. LOCK
D. GBP0
Answer: B
Explanation:
Q33. 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:
Updated C2090-612 test question:
Q34. Which connection type can exploit trusted connections?
A. IMS
B. CAF
C. CICS
D. RRSAF
Answer: D
Explanation:
Q35. 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:
Q36. 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:
Realistic C2090-612 interactive bootcamp:
Q37. The available window to reorganize table spaces is being reduced. What data can provide information to allow for a priority list of candidate table spaces for reorganization based on recent activity with no recent RUNSTATS execution?
A. SYSIBM.SYSCOPY
B. SYSIBM.SYSTABLES
C. SYSIBM.SYSINDEXES
D. SYSIBM.SYSTABLESPACESTATS
Answer: D
Explanation:
Q38. Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pending state AND creates an entry in SYSIBM.SYSCOPY?
A. Run the BACKUP SYSTEM utility.
B. Run the REPAIR SET NOCOPYPEND utility.
C. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.
D. Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 - 10.
Answer: C
Q39. 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:
Q40. Unnecessary REORGs of indexes may be avoided by which of the following?
A. Use the SYSIBM.SYSINDEXSPACESTATS table.
B. Use the REPORT utility to determine the degree of organization.
C. Use the CHANGELIMIT keyword when creating an image copy of the index.
D. Use the CHECK INDEX utility to find out if the index needs to be reorganized.
Answer: A
Explanation: