質問 1：
DB2 10 is in enabling-new-function mode* after migrating from Version 8, which statement is correct?
A. The asterisk (*) indicates objects created in NFM can no longer be accessed.
B. The DB2 subsystem wasat some point in in NFM.
C. The DB2 subsystem can still fall back to DB2 Version 8.
D. Coexistence is allowed with a DB2 9 data sharing group member.
正解：B
質問 2：
Altering the DSSIZE is allowed for what type of table space?
A. Universal table space.
B. Segmented table space.
C. DSSIZEcannot be altered.
D. XML table space.
正解：A
質問 3：
Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?
A. TheDB2 audit trace.
B. The DB2 statistics trace.
C. The DB2 connection trace.
D. The DB2 accounting trace.
正解：B
質問 4：
Which of the following types of table spaces allow multiple tables?
A. Partition-by-growth
B. LOB table space
C. Segmented
D. Partition-by-range
正解：C
質問 5：
During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?
A. LRSN
B. RBA
C. ROWID
D. SYSPITRT
正解：A
質問 6：
What is the purpose of the following query? SELECT DBNAME, NAME FROM
SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME,
TP.TSNAMEFROM SYSIBM.SYSTABLEPART TP WHERE TP.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 whichtable spaces have missing related rows in SYSIBM.SYSTABLEPART.
正解：D
質問 7：
Which stored procedures need to be set up properly in order to register an XML schema?
A. XSR_ADD_SCHEMA
B. The commands to register a XML schema do not invoke stored procedures.
C. XSR_REGISTER and XSR_COMPLETE
D. XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE
正解：C
質問 8：
What START TRACE command provides detailed lock suspend and lock contention trace information?
A. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)
B. START TRACE(AUDIT)
C. START TRACE(PERFM) CLASS(30) IFCID(44,45)
D. START TRACE(STATS) CLASS(1)
正解：C
質問 9：
If security administration isseparated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?
A. INSTALL SYSOPR
B. SYSADM
C. SECADM
D. DBADM
正解：C
DB2 10 is in enabling-new-function mode* after migrating from Version 8, which statement is correct?
A. The asterisk (*) indicates objects created in NFM can no longer be accessed.
B. The DB2 subsystem wasat some point in in NFM.
C. The DB2 subsystem can still fall back to DB2 Version 8.
D. Coexistence is allowed with a DB2 9 data sharing group member.
正解：B
質問 2：
Altering the DSSIZE is allowed for what type of table space?
A. Universal table space.
B. Segmented table space.
C. DSSIZEcannot be altered.
D. XML table space.
正解：A
質問 3：
Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?
A. TheDB2 audit trace.
B. The DB2 statistics trace.
C. The DB2 connection trace.
D. The DB2 accounting trace.
正解：B
質問 4：
Which of the following types of table spaces allow multiple tables?
A. Partition-by-growth
B. LOB table space
C. Segmented
D. Partition-by-range
正解：C
質問 5：
During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?
A. LRSN
B. RBA
C. ROWID
D. SYSPITRT
正解：A
質問 6：
What is the purpose of the following query? SELECT DBNAME, NAME FROM
SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME,
TP.TSNAMEFROM SYSIBM.SYSTABLEPART TP WHERE TP.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 whichtable spaces have missing related rows in SYSIBM.SYSTABLEPART.
正解：D
質問 7：
Which stored procedures need to be set up properly in order to register an XML schema?
A. XSR_ADD_SCHEMA
B. The commands to register a XML schema do not invoke stored procedures.
C. XSR_REGISTER and XSR_COMPLETE
D. XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE
正解：C
質問 8：
What START TRACE command provides detailed lock suspend and lock contention trace information?
A. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)
B. START TRACE(AUDIT)
C. START TRACE(PERFM) CLASS(30) IFCID(44,45)
D. START TRACE(STATS) CLASS(1)
正解：C
質問 9：
If security administration isseparated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?
A. INSTALL SYSOPR
B. SYSADM
C. SECADM
D. DBADM
正解：C
0 お客様のコメント