665 お客様のコメント
質問 1：
What is the maximum levels of backup that DB2 plan stability can support?
A. 4
B. 1
C. 3
D. 2
正解：C
質問 2：
Which DSNZPARM parameter controls thenumber of locks that may be acquired on a table space?
A. MAXUSRS
B. MXDTCACH
C. NUMLKUS
D. NUMLKTS
正解：D
質問 3：
In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)
A. Column CLUSTERRATIOF in SYSIBM.SYSINDEXES
B. Columns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART
C. Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS
D. Column CLUSTERING in SYSIBM.SYSINDEXES
E. Column LEAFDIST in SYSIBM.SYSINDEXPART
正解：C,D
質問 4：
What is one of the first key steps in preparing to use the BACKUP SYSTEM utility?
A. Define one or more storage groups to a COPYPOOL.
B. Alter the BSDS to allow BACKUP SYSTEM.
C. Run the MODIFY RECOVERY utility.
D. Stop DB2 to enable DFSMShsm functionality to be used.
正解：A
質問 5：
When defining a foreign key on a table, which statement is true?
A. You must define an index on the foreign key columns where the index columns are the same as the foreign key columns to guarantee uniqueness of the foreign key.
B. It is not mandatory to have an index on the foreign key columns but it can help performance when you insert rows into this table.
C. It is not mandatory to have anindex on the foreign key columns but it can help to avoid locking problems.
D. There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key checking.
正解：C
質問 6：
When modeling data to provide for a physical design, which of the following defines the data types for the columns in the DB2 physical table?
A. Entities
B. Domain
C. Attributes
D. Primary Key
正解：C
質問 7：
A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?
A. Create a clustering index on the hash columns.
B. Specify the column names to be hashed.
C. Create a unique index on the hash columns.
D. Create a unique clustering index on the hash columns.
正解：B
質問 8：
Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?
A. Make the table space table-partitioned, then issue ALTER TABLESPACE with a validSEGSIZE > 0
B. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
C. Issue ALTER TABLESPACE with a valid SEGSIZE > 0
D. Drop the partitioning index, ALTER the table definition by addingpartition ranges to the existing table definition, create a partitioned index and issue ALTER TABLESPACE with a valid SEGSIZE > 0
正解：A
What is the maximum levels of backup that DB2 plan stability can support?
A. 4
B. 1
C. 3
D. 2
正解：C
質問 2：
Which DSNZPARM parameter controls thenumber of locks that may be acquired on a table space?
A. MAXUSRS
B. MXDTCACH
C. NUMLKUS
D. NUMLKTS
正解：D
質問 3：
In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)
A. Column CLUSTERRATIOF in SYSIBM.SYSINDEXES
B. Columns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART
C. Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS
D. Column CLUSTERING in SYSIBM.SYSINDEXES
E. Column LEAFDIST in SYSIBM.SYSINDEXPART
正解：C,D
質問 4：
What is one of the first key steps in preparing to use the BACKUP SYSTEM utility?
A. Define one or more storage groups to a COPYPOOL.
B. Alter the BSDS to allow BACKUP SYSTEM.
C. Run the MODIFY RECOVERY utility.
D. Stop DB2 to enable DFSMShsm functionality to be used.
正解：A
質問 5：
When defining a foreign key on a table, which statement is true?
A. You must define an index on the foreign key columns where the index columns are the same as the foreign key columns to guarantee uniqueness of the foreign key.
B. It is not mandatory to have an index on the foreign key columns but it can help performance when you insert rows into this table.
C. It is not mandatory to have anindex on the foreign key columns but it can help to avoid locking problems.
D. There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key checking.
正解：C
質問 6：
When modeling data to provide for a physical design, which of the following defines the data types for the columns in the DB2 physical table?
A. Entities
B. Domain
C. Attributes
D. Primary Key
正解：C
質問 7：
A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?
A. Create a clustering index on the hash columns.
B. Specify the column names to be hashed.
C. Create a unique index on the hash columns.
D. Create a unique clustering index on the hash columns.
正解：B
質問 8：
Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?
A. Make the table space table-partitioned, then issue ALTER TABLESPACE with a validSEGSIZE > 0
B. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
C. Issue ALTER TABLESPACE with a valid SEGSIZE > 0
D. Drop the partitioning index, ALTER the table definition by addingpartition ranges to the existing table definition, create a partitioned index and issue ALTER TABLESPACE with a valid SEGSIZE > 0
正解：A
Kiyono -
C2090-612は参考書として、重要ポイント編で要点学習、確認問題で理解度チェックができます。