Refined of C2090-614 free practice questions materials and torrent for IBM certification for 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
Q21. What must you do before an online table space backup operation can be performed?
A. Create a full database backup image.
B. Create one or more tables in the table space.
C. Create an incremental backup image of the table space.
D. Set the DB2_ENABLE_ONLINEBKUP registry variable to ON.
Answer: A
Q22. What advantage do block-based buffer pools offer compared to regular buffer pools?
A. They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.
B. They improve the performance of random I/O by reading non-contiguous pages from disk and writing them into near-contiguous free space in a buffer pool.
C. They improve the performance of vectored reads by retrieving non-contiguous pages from disk, combining them into extent-sized blocks, and writing the blocks into contiguous pages in a buffer pool.
D. They improve the performance of scattered writes by retrieving non-contiguous pages from a buffer pool, combining them into extent-sized blocks, and writing the blocks into contiguous pages on disk.
Answer: A
Q23. Which statement about block indexes is correct?
A. Because of their large size, block indexes are extremely efficient.
B. Block indexes improve performance when data is not clustered on sequential pages.
C. Prefetching of data pages relies on sequential detection when block indexes are used.
D. The records for each block are retrieved using a mini-relational scan of saved data pages.
Answer: C
Q24. A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2 10.1. When will a default storage group be defined for this database?
A. The first time the database is accessed after the migration.
B. The first time the CREATE STOGROUP statement is executed.
C. When the ALTER DATABASE mydb CONVERT statement is used to convert the database to an automatic storage database.
D. When the ALTER TABLESPACE statement is used to convert the table space that holds the system catalog for the database to automatic storage.
Answer: B
Q25. Which table function can be used to determine whether all of a particular table space data objects have been moved from one storage group toWhich table function can be used to determine whether all of a particular table space? data objects have been moved from one storage group to another?
A. MON_GET_TABLESPACE
B. ADMIN_GET_STOGROUP_INFO
C. ADMIN_GET_STORAGE_PATHS
D. MON_GET_REBALANCE_STATUS
Answer: D
Q26. 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
Q27. Which type of storage is utilized in the implementation of an effective and flexible multi-temperature database?
A. System managed storage
B. Automatic storage utilizing storage groups
C. System managed storage utilizing storage groups
D. Database managed storage with file system caching
Answer: B
Q28. For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE command?
A. It will backup just the catalog partition.
B. It will backup all partitions simultaneously.
C. It will backup just the partition that the command is executed from.
D. It will backup just the partitions that reside on the host that the command is executed from.
Answer: C
Q29. 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
Q30. Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
A. Check constraints
B. Default constraints
C. Informational constraints
D. Referential integrity constraints
Answer: C