Want to pass your DB2 10 DBA for z/OS C2090-612 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?
A. Filter factor information.
B. Stage 1 and stage 2 information.
C. Number of columns used in an index.
D. Number of times an SQL statement is executed.
If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?
A. Nothing because DB2 will control the values.
B. A unique index must be defined on the ROWID column.
C. An identity column must also be created to control uniqueness.
D. Extra space must be allocated for an overflow area in the table space.
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.