Real of C2090-612 answers materials and study guides for IBM certification for client, 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:
Q11. If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?
A. The next sort step will perform two sorts.
B. There are multiple sorts in the plan step.
C. One sort in the plan step will accomplish two tasks.
D. Two sorts are performed on the new table of a star join.
Answer: C
Explanation:
Q12. When is a merge scan join a well performing access path?
A. When the number of qualifying rows of the inner and outer table are both large.
B. When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.
C. When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.
D. When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.
Answer: A
Explanation:
Q13. 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:
Regenerate C2090-612 free draindumps:
Q14. What kind of information is stored in SYSIBM.SYSCOPY?
A. General information needed for recovery.
B. Only information about existing image copies.
C. Information about currently running and stopped copy jobs.
D. Only information about objects which are currently in copy pending.
Answer: A
Explanation:
Q15. An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?
A. col2 is converted to EBCDIC
B. col1 is converted to UNICODE
C. SQLCode-270: Function not supported
D. col2 and col1 are converted to UTF-32
Answer: B
Explanation:
Q16. 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
Actual C2090-612 answers:
Q17. What START TRACE command provides detailed lock suspend and lock contention trace information?
A. START TRACE(AUDIT)
B. START TRACE(STATS) CLASS(1)
C. START TRACE(PERFM) CLASS(30) IFCID(44,45)
D. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)
Answer: C
Explanation:
Q18. The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired. To provide additional information on update patterns for the new Billing Application, the DBA can use what information to better understand the unpredictable workload patterns on the tablespaces?
A. SYSIBM.SYSCOPY
B. SYSIBM.SYSSTATS
C. SYSIBM.SYSTABLES
D. SYSIBM.SYSTABLESPACESTATS
Answer: D
Explanation:
Q19. Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS);
A. The index must be partitioned.
B. The index must use page size > 4K.
C. The index must be defined as UNIQUE.
D. The index must be defined as CLUSTER.
Answer: C
Explanation:
Q20. Which ALTER TABLE statement will generate a new table space version?
A. ALTER TABLE ... ADD PARTITION ...
B. ALTER TABLE ... ADD COLUMN COL2 ...
C. ALTER TABLE ... DATA CAPTURE CHANGES ...
D. Altering an already existing VARCHAR column on the table to shorten its maximum length.
Answer: B
Explanation: