Cause all that matters here is passing the IBM C2090-612 exam. Cause all that you need is a high score of C2090-612 DB2 10 DBA for z/OS exam. The only one thing you need to do is downloading Ucertify C2090-612 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 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
Q11. When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?
A. List prefetch
B. Dynamic prefetch
C. Sequential prefetch
D. Skip sequential prefetch
Answer: B
Explanation:
Q12. 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:
Q13. What is the one significant difference between sequence objects and identity columns?
A. Identity columns can cache values and sequence objects cannot.
B. Identity columns can be defined on tables and sequence objects cannot.
C. Sequence objects can have a character data type and identity columns cannot.
D. Sequence object values can be used as primary keys and identity column values cannot.
Answer: B
Explanation:
Q14. You want to ALTER a table space specifying MAXPARTITIONS 256. For which table space type does the ALTER fail?
A. Simple table space with one table.
B. Segmented table space with one table.
C. Classic partitioned table space with one table.
D. Partitioned-by-growth table space with one table.
Answer: C
Explanation:
Q15. 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:
Q16. 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:
Q17. When modeling data to provide for a physical design, which of the following defines the data types for the columns in the DB2 physical table?
A. Domain
B. Entities
C. Attributes
D. Primary Key
Answer: C
Explanation:
Q18. The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could have caused a table space scan to be chosen instead of the index?
A. Index is created with PCTFREE of zero.
B. The number of columns in the index is less than four.
C. RUNSTATS were run when there were no rows in the table.
D. RUNSTATS were run when there was a million rows in the table.
Answer: C
Explanation:
Q19. What WLM action will establish performance objectives for DDF threads and their related address space?
A. Insure the NUMTCB is set to a value greater than 10.
B. Specify DDF for the value of APPLENV to the name of the WLM environment.
C. Execute the WLM_REFRESH stored procedure for the DDF application environment.
D. Create a WLM service definition that assigns service classes to the DDF threads.
Answer: D
Explanation:
Q20. 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: