最新的IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows - C2090-614免費考試真題

A. SYSUSERDEFAULTWLM

B. DEFAULT_USER

C. SYSDEFAULTUSERWORKLOAD

D. SYS_DEFAULT_USER_WORKLOAD

A. ASYNC

B. SUPERASYNC

C. SYNC

D. NEARSYNC

A. A snapshot monitor

B. A statement event monitor

C. db2dart

D. The MON_GET_UNIT_OF_WORK_DETAILS table function

A. The ALTER TABLE statement can be used to change the physical structure of an RCT.

B. The minimum value of a key column for an RCT cannot be a negative value.

C. Storage space is not pre-allocated for an RCT.

D. When defining a range of key values for an RCT, a minimum value is optional.

A. The page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL statement.

B. The database has to be restarted before the MYBP buffer pool will become active.

C. Self tuning is enabled for the MYBP buffer pool.

D. The initial size for the MYBP buffer pool is zero pages.

A. To improve insert/delete performance for tables in an OLTP database.

B. To improve query performance in a data warehouse environment.

C. To improve index performance in a data warehouse environment.

D. To improve access performance for tables in an OLTP database.

A. Data types can be mapped in both directions between a remote and local data type.

B. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.

C. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.

D. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.

A. It helps identify data access patterns to aid in storage planning.

B. It helps reduce storage costs for infrequently accessed data.

C. It helps reduce redundant I/O.

D. It helps improve data compression ratios.