977 お客様のコメント
質問 1：
When is a merge scan join a well performing access path?
A. When the number of qualifying rows of the inner and outer table are both large.
B. When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.
C. When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.
D. When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.
正解：A
質問 2：
What is the purpose of the following query? SELECT DBNAME, NAME FROM
SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME,
TP.TSNAME FROM SYSIBM.SYSTABLEPART TP WHERETP.DBNAME = TS.DBNAME
AND TP.TSNAME = TS.NAME);
A. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.
B. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.
C. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.
D. It identifies which table spaces have missing relatedrows in SYSIBM.SYSTABLEPART.
正解：D
質問 3：
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
質問 4：
Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
A. ALTER TABLE TB1 ADD COLUMN COLC DATE;
B. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS
SECURITY LABEL;
C. ALTER TABLE TB1 AUDIT CHANGES;
D. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
正解：A
質問 5：
You have to design a table and application layout, in which automatic number generationis used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which statement is true?
A. Identity and Sequence can both deliver this functionality.
B. Neither Identity nor Sequence can deliver this functionality.
C. Identity cannot deliver this functionality, but Sequence can.
D. Identity can deliver this functionality, but Sequence cannot.
正解：C
When is a merge scan join a well performing access path?
A. When the number of qualifying rows of the inner and outer table are both large.
B. When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.
C. When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.
D. When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.
正解：A
質問 2：
What is the purpose of the following query? SELECT DBNAME, NAME FROM
SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME,
TP.TSNAME FROM SYSIBM.SYSTABLEPART TP WHERETP.DBNAME = TS.DBNAME
AND TP.TSNAME = TS.NAME);
A. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.
B. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.
C. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.
D. It identifies which table spaces have missing relatedrows in SYSIBM.SYSTABLEPART.
正解：D
質問 3：
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
質問 4：
Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
A. ALTER TABLE TB1 ADD COLUMN COLC DATE;
B. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS
SECURITY LABEL;
C. ALTER TABLE TB1 AUDIT CHANGES;
D. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
正解：A
質問 5：
You have to design a table and application layout, in which automatic number generationis used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which statement is true?
A. Identity and Sequence can both deliver this functionality.
B. Neither Identity nor Sequence can deliver this functionality.
C. Identity cannot deliver this functionality, but Sequence can.
D. Identity can deliver this functionality, but Sequence cannot.
正解：C
村上** -
試験に合格するために必須の基本知識がこのC2090-612問題集一つでで短時間に修得できると思います。Pass4Testの問題集はいつも素敵でございますね。