Accurate of C2090-614 test question materials and paper for IBM certification for IT candidates, Real Success Guaranteed with Updated C2090-614 pdf dumps vce Materials. 100% PASS DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) exam Today!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-614 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-614 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-614-exam-dumps.html
Q41. Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?
A. Data class, work class, and a limit
B. Data class, action class, and a threshold
C. Service subclass, action class, and a limit
D. Service subclass, work class, and a threshold
Answer: D
Q42. To configure instance-level auditing with db2audit, which authority is required?
A. SYSADM
B. SYSCTRL
C. SECADM
D. SYSMAINT
Answer: A
Q43. A table named MYTAB was created as follows:
How many rows will be inserted into the MYTAB table?
A. 4
B. 8
C. 11
D. 12
Answer: B
Q44. Which statement about SMS table spaces is correct?
A. The system catalog cannot be stored in an SMS table space.
B. Tables, large objects (LOBs), and indexes can each reside in separate SMS table spaces.
C. SMS table spaces are recommended when you have small tables that are not likely to grow quickly.
D. Extents are more likely to be contiguous with SMS table spaces than they are with DMS table spaces.
Answer: C
Q45. Which statement about partitioned indexes is FALSE?
A. Both system- and user-generated indexes can be partitioned.
B. Each index partition contains references only to data in its corresponding data partition.
C. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition
D. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the corresponding partition index.
Answer: D
Q46. What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)
A. Table space available space
B. Table space read and write activity
C. Table space container assignments
D. Table level activity within a table space
E. Table space backup and recovery information
Answer: A,B
Q47. What statement regarding Asynchronous index cleanup (AIC) is correct?
A. AIC removes all invalid index entries that refer to the attached partitions.
B. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.
C. AIC activates a newly attached partition after the index entries have been synchronized.
D. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).
Answer: B
Q48. Which statement about the initiation of parallel I/O is correct?
A. For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
B. For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
C. For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
D. For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
Answer: C
Q49. Which Range-Clustered Tables (RCT) statement is correct?
A. Reverse scans on RCTs are not supported.
B. Clustering indexes are compatible with RCTs.
C. The Design Advisor can recommend the use of RCTs.
D. The IMPORT utility can be used with the REPLACE option to populate RCTs.
Answer: A
Q50. Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?
A. Columns with low cardinalities
B. Columns with high cardinalities
C. Columns involved in roll-in or roll-out of data
D. Columns involved in equality or range predicate queries
Answer: B