質問 1：
What is the default user workload class that is created for each database table?
A. SYSUSERDEFAULTWLM
B. SYSDEFAULTUSERWORKLOAD
C. SYS_DEFAULT_USER_WORKLOAD
D. DEFAULT_USER
正解：B
質問 2：
A storage group named HOT_SG was created as follows:
What does the DATA TAG 1 clause do?
A. 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.
B. 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.
C. It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.
D. 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
質問 3：
What is the preferred method for reclaiming unused storage in a DMS table space?
A. Perform an ALTER TABLESPACE...REDUCE operation.
B. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation.
C. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation.
D. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)
質問 4：
What statement regarding Asynchronous index cleanup (AIC) is correct?
A. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.
B. AIC activates a newly attached partition after the index entries have been synchronized.
C. AIC removes all invalid index entries that refer to the attached partitions.
D. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).
正解：A
質問 5：
Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?
A. Service subclass, work class, and a threshold
B. Data class, work class, and a limit
C. Data class, action class, and a threshold
D. Service subclass, action class, and a limit
正解：A
質問 6：
A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2
10.1. When will a default storage group be defined for this database?
A. When the ALTER DATABASE mydb CONVERT statement is used to convert the database to an automatic storage database.
B. When the ALTER TABLESPACE statement is used to convert the table space that holds the system catalog for the database to automatic storage.
C. The first time the database is accessed after the migration.
D. The first time the CREATE STOGROUP statement is executed.
正解：D
What is the default user workload class that is created for each database table?
A. SYSUSERDEFAULTWLM
B. SYSDEFAULTUSERWORKLOAD
C. SYS_DEFAULT_USER_WORKLOAD
D. DEFAULT_USER
正解：B
質問 2：
A storage group named HOT_SG was created as follows:
What does the DATA TAG 1 clause do?
A. 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.
B. 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.
C. It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.
D. 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
質問 3：
What is the preferred method for reclaiming unused storage in a DMS table space?
A. Perform an ALTER TABLESPACE...REDUCE operation.
B. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation.
C. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation.
D. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)
質問 4：
What statement regarding Asynchronous index cleanup (AIC) is correct?
A. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.
B. AIC activates a newly attached partition after the index entries have been synchronized.
C. AIC removes all invalid index entries that refer to the attached partitions.
D. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).
正解：A
質問 5：
Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?
A. Service subclass, work class, and a threshold
B. Data class, work class, and a limit
C. Data class, action class, and a threshold
D. Service subclass, action class, and a limit
正解：A
質問 6：
A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2
10.1. When will a default storage group be defined for this database?
A. When the ALTER DATABASE mydb CONVERT statement is used to convert the database to an automatic storage database.
B. When the ALTER TABLESPACE statement is used to convert the table space that holds the system catalog for the database to automatic storage.
C. The first time the database is accessed after the migration.
D. The first time the CREATE STOGROUP statement is executed.
正解：D
0 お客様のコメント