최신IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows - C2090-614무료샘플문제

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

B. Reduce the current high water mark of all table spaces that have been assigned to a storage group.

C. Change the name of an existing storage group.

D. Make an existing storage group the default storage group.

A. Service subclass, action class, and a limit

B. Data class, work class, and a limit

C. Data class, action class, and a threshold

D. Service subclass, work class, and a threshold

A. Statements generating audit records must wait for the records to be written to disk before they can complete execution.

B. There is no limit to how many audit records can be stored in an internal memory buffer for one single statement generating audit records.

C. The audit facility writes records to disk at the same time the statements generating the audit records are executing.

D. The writing of audit records to disk will be delayed until a minimum number of records (based on record size and memory available in the database heap) have been generated.

A. Columns involved in equality or range predicate queries

B. Columns with low cardinalities

C. Columns with high cardinalities

D. Columns involved in roll-in or roll-out of data

A. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.

B. It can be used to merge offline backups to build full offline table space backups.

C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.

D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.

A. Execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table.

B. Create an MDC table and then move the data in the base table to the MDC table with the db2move command.

C. Export the data, create an MDC table, and then import or load the data into the MDC table.

D. Export the data, execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table, and then import or load the datainto the converted table.

A. MON_GET_TABLESPACE

B. ADMIN_GET_STOGROUP_INFO

C. ADMIN_GET_STORAGE_PATHS

D. MON_GET_REBALANCE_STATUS

A. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.

B. A range-clustered table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.

C. A range-partitioned table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.

D. A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.