Act now and download your IBM C2090-614 test today! Do not waste time for the worthless IBM C2090-614 tutorials. Download Renew IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) exam with real questions and answers and begin to learn IBM C2090-614 with a classic professional.
♥♥ 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
Q11. Which item is NOT eligible for adaptive compression?
A. Indexes
B. Base tables
C. Temporary tables
D. Inline LOB values
Answer: C
Q12. Which monitoring tool can be used to find out how many data pages have been read from the table space containers for regular, large, and temporary table spaces?
A. The MON_DB_SUMMARY administrative view.
B. The MON_BP_UTILIZATION administrative view.
C. The MON_GET_ACTIVITY_DETAILS table function.
D. The MON_GET_EXTENT_MOVEMENT_STATUS table function.
Answer: B
Q13. On which two operating systems can DB2 pureScale run? (Choose two.)
A. AIX
B. Linux
C. HP-UX
D. Solaris
E. Windows
Answer: A,B
Q14. 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
Q15. Given the following output: Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?
A. EXPLAIN_FROM_DATA
B. EXPLAIN_FROM_ACTIVITY
C. EXPLAIN_FROM_SECTION
D. EXPLAIN_FROM_CATALOG
Answer: B
Q16. A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have been assigned to this group. What kind of table spaces must the DBA assign to the storage group before the desired tables can be created?
A. Automatic storage (AS) table spaces
B. System managed space (SMS) table spaces
C. Database managed space (DMS) table spaces that use FILE containers
D. Database managed space (DMS) table spaces that use RAW containers
Answer: A
Q17. What is a benefit of multi-temperature data storage?
A. It helps reduce redundant I/O.
B. It helps improve data compression ratios.
C. It helps reduce storage costs for infrequently accessed data.
D. It helps identify data access patterns to aid in storage planning.
Answer: C
Q18. Which statement about DB2 Merge Backup is FALSE?
A. It can be used to merge offline backups to build full offline table space backups.
B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.
D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.
Answer: B
Q19. Which statement about Range Clustered Tables (RCT) is correct?
A. Storage space is not pre-allocated for an RCT.
B. The ALTER TABLE statement can be used to change the physical structure of an RCT.
C. When defining a range of key values for an RCT, a minimum value is optional.
D. The minimum value of a key column for an RCT cannot be a negative value.
Answer: C
Q20. Which category must be enabled before db2audit will record the creation of new buffer pools?
A. OBJMAINT
B. SECMAINT
C. CHECKING
D. OBJCREATE
Answer: A