689 お客様のコメント
質問 1：
What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?
A. To terminate a failed INGEST command.
B. To clean up the log records of a failed INGEST command.
C. To restart a failed INGEST command from the last commit point.
D. To restart a failed INGEST command from the beginning.
正解：C
質問 2：
Which statement is NOT true about a database restore operation?
A. A table space is not usable until the restore operation completes successfully.
B. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.
C. A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.
D. A table space restore operation must be done offline.
正解：D
質問 3：
If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?
A. Self-tuning is occurring only on the instance memory area.
B. The memory tuner is actively tuning the memory on the system.
C. Self-tuning is not occurring because there are less than two memory consumers enabled.
D. Self-tuning is not occurring because it is waiting for the database to be recycled.
正解：C
質問 4：
Which authorities can be audited with the AUDIT statement?
A. SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.
B. DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and SECADM cannot.
C. SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.
D. SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.
正解：C
質問 5：
Which statement about range-clustered tables is true?
A. Range-clustered tables can be used in a DB2 pureScale environment.
B. Range-clustered tables can be used with value and default compression.
C. Range-clustered tables can be used with multiple-column keys.
D. Range-clustered tables can be used with the REORG utility.
正解：C
質問 6：
What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?
A. CPU cycles
B. Processing instructions performed
C. Elapsed time, in milliseconds
D. Timerons
正解：D
質問 7：
Which statement about primary keys is true?
A. A primary key accepts one, and only one, NULL value.
B. A unique index, with matching columns of the primary key, must be created before a primary key can be created.
C. A table can have multiple primary keys.
D. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.
正解：D
What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?
A. To terminate a failed INGEST command.
B. To clean up the log records of a failed INGEST command.
C. To restart a failed INGEST command from the last commit point.
D. To restart a failed INGEST command from the beginning.
正解：C
質問 2：
Which statement is NOT true about a database restore operation?
A. A table space is not usable until the restore operation completes successfully.
B. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.
C. A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.
D. A table space restore operation must be done offline.
正解：D
質問 3：
If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?
A. Self-tuning is occurring only on the instance memory area.
B. The memory tuner is actively tuning the memory on the system.
C. Self-tuning is not occurring because there are less than two memory consumers enabled.
D. Self-tuning is not occurring because it is waiting for the database to be recycled.
正解：C
質問 4：
Which authorities can be audited with the AUDIT statement?
A. SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.
B. DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and SECADM cannot.
C. SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.
D. SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.
正解：C
質問 5：
Which statement about range-clustered tables is true?
A. Range-clustered tables can be used in a DB2 pureScale environment.
B. Range-clustered tables can be used with value and default compression.
C. Range-clustered tables can be used with multiple-column keys.
D. Range-clustered tables can be used with the REORG utility.
正解：C
質問 6：
What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?
A. CPU cycles
B. Processing instructions performed
C. Elapsed time, in milliseconds
D. Timerons
正解：D
質問 7：
Which statement about primary keys is true?
A. A primary key accepts one, and only one, NULL value.
B. A unique index, with matching columns of the primary key, must be created before a primary key can be created.
C. A table can have multiple primary keys.
D. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.
正解：D
庄司** -
A2090-611メインの解説を補足する側注ヒント要素は、解釈でわかりやく内容を明示。つまづきやすいポイントをフォローしてくれてる。