Practical of C2090-612 testing engine materials and testing software for IBM certification for candidates, 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:
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. Which clone table statement is correct?
A. A clone table can have its own indexes.
B. A clone table has its own catalog statistics.
C. The clone and base tables share a table space.
D. The clone and base tables must have different schema names.
Answer: C
Explanation:
Q73. A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?
A. Specify the column names to be hashed.
B. Create a unique index on the hash columns.
C. Create a clustering index on the hash columns.
D. Create a unique clustering index on the hash columns.
Answer: A
Explanation:
Regenerate C2090-612 practice exam:
Q74. When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of the different page sizes?
A. DIAGNOSE
B. DSN1COMP
C. DSN1PRNT
D. DSN1LOGP
Answer: B
Explanation:
Q75. What IBM provided stored procedure will access DB2 real time statistics tables?
A. DSNAEXP
B. DSNAIMS
C. DSNACCOX
D. DSNLEUSR
Answer: C
Explanation:
Q76. A single table should allow for up to 100 Terabytes of application data. How do you design your table space?
A. A segmented compressed table space, BUFFERPOOL BP0.
B. A LOB table space with DSSIZE 64GB, BUFFERPOOL BP8K0.
C. A table space with NUMPARTS 1024, DSSIZE 64G, BUFFERPOOL BP16K0.
D. A table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K.
Answer: D
Explanation:
Validated C2090-612 questions:
Q77. When specifying "A" for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?
A. An inbound ID is subject to translation.
B. A request does not need an authentication token.
C. With this option, VTAM cannot be defined with SECACPT=ALREADYV.
D. For outbound requests, the encrypted password is extracted from RACF.
Answer: B
Explanation:
Q78. Poorly tuned memory can affect application performance, such as having sequential prefetch turned off. Which statistic should you monitor from the statistics report to be sure this is not occurring?
A. PREF.DISABLED-NO BUFFER
B. PREF.DISABLED-NO READ ENG
C. BUFF.UPDATES/PAGES WRITTEN
D. PAGES WRITTEN PER WRITE I/O
Answer: A
Explanation:
Q79. Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.)
A. Append
B. Inline LOBs
C. Member cluster
D. Volatile table
E. Include columns
Answer: A,C
Explanation:
Q80. Which DB2 online utility job output provides you with information about the BACKUP SYSTEM history?
A. DSNJU003
B. DSNJU004
C. DIAGNOSE
D. REPORT with RECOVERY option
Answer: D
Explanation: