IBM C2090-614 問題集

質問 1：
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. Database managed space (DMS) table spaces that use FILE containers
C. Database managed space (DMS) table spaces that use RAW containers
D. System managed space (SMS) table spaces
正解：A

質問 2：
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_BP_UTILIZATION administrative view.
B. The MON_GET_EXTENT_MOVEMENT_STATUS table function.
C. The MON_DB_SUMMARY administrative view.
D. The MON_GET_ACTIVITY_DETAILS table function.
正解：A

質問 3：
Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?
A. The MON_GET_CONTAINER table function.
B. The SNAPTBSP_RANGE administrative view.
C. The TS_GET_CONTAINER administrative view.
D. The SNAP_GET_TBSP_PART table function.
正解：A

質問 4：
If a large amount of sequential prefetching is occurring, what can be done to improve efficiency?
A. Set SEQDETECT to NO.
B. Allocate a block-based area in the appropriate buffer pool.
C. Create indexes that encourage the optimizer to use index-only access.
D. Set NUMBLOCKPAGES to 0 in all buffer pools.
正解：B

質問 5：
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 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.
C. 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.
D. 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.
正解：A

質問 6：
What is the recommended method for removing old backup images and log files for a DB2
10.1 database?
A. Set the DB2PRUNE_ACTION_LOG configuration parameter to a desired date before
generating a new backup.
B. Utilize the PRUNE LOGFILE PRIOR TO command to remove old backups and logs.
C. Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.
D. Manually delete old backups and logs.
正解：C

質問 7：
A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of several columns in the SQL Server data source are changed?
A. Drop the current data type mapping. Create the new data type mapping.
B. Drop the current data type mapping. Create the new data type mapping. Drop the nickname to the table. Recreate the nickname to the table.
C. Drop the nickname to the table. Create the new data type mapping. Recreate the nickname to the table.
D. Drop the current user mapping. Drop the current data type mapping. Create the new user mapping. Create the new data type mapping. Recreate the nickname to the table.
正解：C