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.
What will occur when a database administrator adds a new automatic storage path to an existing storage group?
A. New table spaces will start consuming storage on the new path.
B. Existing table spaces will not consume storage on the new path.
C. The storage group will be placed in "Rebalance Pending" mode.
D. DB2 will verify that space is available on the storage path specified.
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.
On which two operating systems can DB2 pureScale run? (Choose two.)
A. AIX
B. Linux
C. HP-UX
D. Solaris
E. Windows
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.
Which statement about Range-Clustered Tables (RCTs) is correct?
A. More logging is required compared to similarly-sized regular tables.
B. More buffer pool memory is required to store the table's B+ index structure.
C. Space is pre-allocated and reserved for use by the table even when records do not yet exist.
D. More maintenance is required since indexes must be updated after every insert, update, or delete operation.
Which statement about Insert-Time-Clustered (ITC) is correct?
A. Views cannot be created on ITC tables.
B. ITC tables do not support row compression.
C. Block indexes cannot be created for ITC tables.
D. ITC tables can release their empty pages to the operating system.
The following query is executed frequently against the SALES table:
SELECT sales_id, sales_date, sales_person FROM sales;
If data in the SALES_ID column is unique,
Which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?
A. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
B. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
C. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
Which operation can be performed by executing an ALTER STOGROUP statement?
A. Change the name of an existing storage group.
B. Make an existing storage group the default storage group.
C. Reduce the current high water mark of all table spaces that have been assigned to a storage group.
D. Specify the average time, in milliseconds, that it takes to read one page of data from the slowest storage path used by a storage group.
In what situation should you use a redirected restore operation?
A. You want to drop a storage group during a restore process.
B. You want to move data from one operating system to another.
C. You want to restore you table spaces into new storage groups.
D. You want to restore your table space containers into a different physical location.
