Act now and download your IBM C2090-612 test today! Do not waste time for the worthless IBM C2090-612 tutorials. Download Renewal IBM DB2 10 DBA for z/OS exam with real questions and answers and begin to learn IBM C2090-612 with a classic professional.
♥♥ 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
Q41. If security administration is separated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?
A. SYSADM
B. DBADM
C. SECADM
D. INSTALL SYSOPR
Answer: C
Explanation:
Q42. What is a consideration when specifying DATA CAPTURE CHANGES?
A. Can be specified for capturing changes to an XML object.
B. To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified.
C. REFRESH TABLE statement is not allowed with a table defined with DATA CAPTURE CHANGES.
D. You cannot turn on DATA CAPTURE CHANGES if the table space is in advisory REORG-pending.
Answer: D
Explanation:
Q43. 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:
Q44. What trace class will show deadlock information?
A. Audit class 3.
B. Statistic class 3.
C. Accounting class 1.
D. Performance class 8.
Answer: B
Explanation:
Q45. What is a potential consideration when using triggers?
A. They are not invoked by the LOAD REPLACE utility.
B. When using views, the underlying tables cannot have a trigger defined.
C. RI and check constraints are evaluated prior to any trigger invocation.
D. They run in a WLM managed address space, so invoking them frequently (e.g. when using a row level trigger) can be costly.
Answer: A
Explanation:
Q46. 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:
Q47. 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:
Q48. Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth table space?
A. MAXPARTITIONS
B. MAXPARTITIONS, DSSIZE
C. MAXPARTITIONS, page size
D. MAXPARTITIONS, DSSIZE, page size
Answer: D
Explanation:
Q49. 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:
Q50. What must be in place for the support of index compression?
A. User defined algorithm.
B. Compression dictionary.
C. Table space compression.
D. Page size larger than 4K.
Answer: D
Explanation: