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

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. Table space backup and recovery information

B. Table space container assignments

C. Table space available space

D. Table space read and write activity

E. Table level activity within a table space

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.

A. It will backup just the partition that the command is executed from.

B. It will backup just the catalog partition.

C. It will backup all partitions simultaneously.

D. It will backup just the partitions that reside on the host that the command is executed from.

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. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition

B. Each index partition contains references only to data in its corresponding data partition.

C. Both system- and user-generated indexes can be partitioned.

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.

A. The storage group SG_1 was not the current default storage group at the time a new storage path was being added to it.

B. The current default storage group cannot be dropped.

C. New storage paths cannot be added to existing storage groups.

D. The storage group IBMSTOGROUP cannot be dropped because it is a system-defined storage group.