Exam Code: C2090-612 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10 DBA for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-612 Exam.
2021 May C2090-612 Study Guide Questions:
Q41. You have to design a numeric column, which is also the primary key. The column should cover large (i.e., 123456789012345678) numbers. Which column data definition covers the requirements?
A. BIGINT
B. INTEGER
C. DECFLOAT (34)
D. DECIMAL (31,18)
Answer: A
Explanation:
Q42. Using the -SET LOG command, what logging characteristics CANNOT be modified?
A. The number of minutes between the start of successive checkpoints.
B. Add a newly defined active log data set to the active log inventory.
C. Altering DB2 from dual active logging mode to single active logging mode.
D. The number of log records that DB2 writes between the start of successive checkpoints.
Answer: C
Explanation:
Q43. What is the maximum levels of backup that DB2 plan stability can support?
A. 1
B. 2
C. 3
D. 4 Answer: C
Explanation:
Up to the minute C2090-612 exam guide:
Q44. Which of the following statements is NOT correct?
A. UNLOAD with NOPAD improves performance.
B. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).
C. Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.
D. Clone table allows replacing data without renames and rebinds to support online load replace.
Answer: B
Q45. Which minimum system privilege allows you to create a trusted context?
A. DBADM
B. SECADM
C. SYSCTRL
D. ACCESSCTRL
Answer: B
Explanation:
Q46. Which option allows the UNLOAD utility to unload LOBs into output files together with non-LOB data?
A. DELIMITED
B. SPANNED YES
C. DSNTYPE HFS on the TEMPLATE
D. DSNTYPE LIBRARY or PDS on the TEMPLATE
Answer: B
Explanation:
Exact C2090-612 keys:
Q47. On what type of index would an ALTER INDEX ADD COLUMN be allowed?
A. An XML index.
B. An auxiliary index.
C. A user defined catalog index.
D. An index defined with BUSINESS_TIME WITHOUT OVERLAPS.
Answer: C
Explanation:
Q48. 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:
Q49. Which DB2 trace has potentially the highest level of overhead, and should typically be run in specific situations and only for short durations?
A. The DB2 audit trace.
B. The DB2 statistics trace.
C. The DB2 accounting trace.
D. The DB2 performance trace.
Answer: D
Explanation:
Q50. 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: