最新なIBM C2090-614問題集（110題）、真実試験の問題を全部にカバー！

質問 1：
Which statement about SMS table spaces is correct?
A. Tables, large objects (LOBs), and indexes can each reside in separate SMS table spaces.
B. Extents are more likely to be contiguous with SMS table spaces than they are with DMS table spaces.
C. SMS table spaces are recommended when you have small tables that are not likely to grow quickly.
D. The system catalog cannot be stored in an SMS table space.
正解：C

質問 2：
Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?
A. Columns with low cardinalities
B. Columns involved in equality or range predicate queries
C. Columns with high cardinalities
D. Columns involved in roll-in or roll-out of data
正解：C

質問 3：
On which two operating systems can DB2 pureScale run? (Choose two.)
A. Windows
B. HP-UX
C. AIX
D. Solaris
E. Linux
正解：C,E

質問 4：
Which command will be executed successfully on every database partition if db2_all is used?
A. CONNECT
B. FORCE APPLICATION
C. ACTIVATE DATABASE
D. RESTART DATABASE
正解：D

質問 5：
Which would not significantly benefit from having the RUNSTATS command run on it?
A. Tables where a new index has been created.
B. Tables that have been reorganized (using REORG).
C. Tables that have had little change.
D. Tables that have been populated with a LOAD operation.
正解：C

質問 6：
Which statement about the initiation of parallel I/O is correct?
A. 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.
B. 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.
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 list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
正解：C

質問 7：
When will the existing data for a new partition be visible to applications querying a range-partitioned table?
A. After the ALTER TABLE ... ADD and SET INTEGRITY statements are executed.
B. After the ALTER TABLE ... ATTACH statement is executed.
C. After the ALTER TABLE ... ATTACH and SET INTEGRITY statements are executed.
D. After the ALTER TABLE ... ADD statement is executed.
正解：C

質問 8：
If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?
A. Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.
B. Issue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.
C. Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.
D. Perform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.
正解：C

質問 9：
Which statement about value compression is correct?
A. To use value compression, you must have a license for the DB2 Storage Optimization Feature.
B. Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.
C. Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.
D. When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same values.
正解：C