IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows - 000-614무료 덤프문제 풀어보기

A. 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.

B. 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.

C. 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.

D. They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.

A. ALTER STOGROUP med_sg ADD ?db2fs5?ALTER STOGROUP med_sg ADD ?db2fs5

B. ALTER STOGROUP med_sg DROP '/db2fs4'

C. ALTER TABLESPACE ts1 ADD '/db2fs4' REBALANCE

D. ALTER TABLESPACE ts1 REBALANCE

A. Read-ahead prefetching

B. Sequential detection prefetching

C. Smart data prefetching

D. Consecutive prefetching

A. It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.

B. It tells the DB2 Optimizer that database objects stored in the HOT_SG storage group are to be given preference over other objects when data access plans are generated.

C. It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group, which Workload Manager (WLM) can then use to determine the processing priority to assign to database activities that interact with this data.

D. It assigns a unique identifier to the instance of the HOT_SG storage group being defined; this identifier can then be used when moving table spaces to and from the storage group, when dropping the storage group, or when commenting on the storage group.

A. overflowlogpath

B. mirrorlogpath

C. logarchopt1

D. failarchpath

A. It uses continuous log shipping to replicate from the source database to the target database.

B. It uses WebSphere MQ message queues to transmit transactions between source and target databases.

C. It uses HADR message queues to transmit transactions between source and target databases.

D. It uses replication control tables and changed data tables to replicate from the source database to the target database.

A. The Design Advisor can recommend the use of RCTs.

B. The IMPORT utility can be used with the REPLACE option to populate RCTs.

C. Reverse scans on RCTs are not supported.

D. Clustering indexes are compatible with RCTs.