1254 お客様のコメント
質問 1：
What is used during Fast Recovery to return pages to the original state?
A. External Tables
B. Temporary DBSpaces
C. Physical Log
D. Logical Log
正解：C
質問 2：
How is the automatic addition of more space triggered?
A. The internal mon_low_storage task.
B. When the instance is restarted.
C. When the limit of the ADD_SPACE onconfig parameter is reached.
D. Via the default alarm program.
正解：A
質問 3：
When running an onstat -u, what does a 'Y' in the first column of the flags signify?
A. The userthread is waiting for end user I/O to complete.
B. The userthread is waiting for a thread to yield a cpu vp.
C. The userthread is waiting for a thread with a higher priority.
D. The userthread is waiting on a condition.
正解：D
質問 4：
By default, the alarm program gets executed for which event(s)?
A. All events.
B. Only for events with Severity code 1.
C. Only for events with Severity code greater than 1.
D. Only for events with Severity code 5.
正解：C
質問 5：
What is a requirement for online attach/detach of fragments?
A. The table cannot have constraints.
B. The table fragmentation scheme and the index fragmentation scheme must be identical.
C. The table must have a remainder fragment.
D. The table must have a unique index.
正解：B
質問 6：
The following shrink command has what effect on the customer table? execute function sysadmin:task("table shrink","customer")
A. Locks the table in exclusive mode and releases all free space at the end of the table.
B. Locks the table in exclusive mode and moves all rows to the beginning of the table.
C. Moves all rows to the beginning of the table while users can modify the table.
D. Releases all free space at the end of the table to the dbspace while users can modify the table.
正解：D
質問 7：
Which statement regarding default roles is true?
A. The privileges associated with a default role takes precedence over the privileges granted to an individual user.
B. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.
C. An administrator can define a default role to assign only to the PUBLIC group for a particular database.
D. An administrator can define a default role to assign to individual users or to the PUBLIC group for a particular database.
正解：D
質問 8：
Which is a valid PAM mode supported by Informix in a UNIX platform?
A. Password mode
B. Login mode
C. Client mode
D. Server mode
正解：A
What is used during Fast Recovery to return pages to the original state?
A. External Tables
B. Temporary DBSpaces
C. Physical Log
D. Logical Log
正解：C
質問 2：
How is the automatic addition of more space triggered?
A. The internal mon_low_storage task.
B. When the instance is restarted.
C. When the limit of the ADD_SPACE onconfig parameter is reached.
D. Via the default alarm program.
正解：A
質問 3：
When running an onstat -u, what does a 'Y' in the first column of the flags signify?
A. The userthread is waiting for end user I/O to complete.
B. The userthread is waiting for a thread to yield a cpu vp.
C. The userthread is waiting for a thread with a higher priority.
D. The userthread is waiting on a condition.
正解：D
質問 4：
By default, the alarm program gets executed for which event(s)?
A. All events.
B. Only for events with Severity code 1.
C. Only for events with Severity code greater than 1.
D. Only for events with Severity code 5.
正解：C
質問 5：
What is a requirement for online attach/detach of fragments?
A. The table cannot have constraints.
B. The table fragmentation scheme and the index fragmentation scheme must be identical.
C. The table must have a remainder fragment.
D. The table must have a unique index.
正解：B
質問 6：
The following shrink command has what effect on the customer table? execute function sysadmin:task("table shrink","customer")
A. Locks the table in exclusive mode and releases all free space at the end of the table.
B. Locks the table in exclusive mode and moves all rows to the beginning of the table.
C. Moves all rows to the beginning of the table while users can modify the table.
D. Releases all free space at the end of the table to the dbspace while users can modify the table.
正解：D
質問 7：
Which statement regarding default roles is true?
A. The privileges associated with a default role takes precedence over the privileges granted to an individual user.
B. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.
C. An administrator can define a default role to assign only to the PUBLIC group for a particular database.
D. An administrator can define a default role to assign to individual users or to the PUBLIC group for a particular database.
正解：D
質問 8：
Which is a valid PAM mode supported by Informix in a UNIX platform?
A. Password mode
B. Login mode
C. Client mode
D. Server mode
正解：A
Mizuhara -
試験合格だけを狙うのであればもっとPass4Test簡易版のテキストでも十分だと思います。中身が濃く、いきなりこのテキストを使うと行き詰るかも。