919 お客様のコメント
質問 1：
Given the following SQL command where the DBSPACETEMP onconfig and environment variables are set to valid dbspaces:
create temp table mytemp (columns) with no log;
in what order will the instance evaluate where to place this table?
A. DBSPACETEMP onconfig parameter variable, root dbspace, dbspace where the database was created, DBSPACETEMP environment variable.
B. DBSPACETEMP onconfig parameter variable, DBSPACETEMP environment variable,
root dbspace, dbspace where the database was created.
C. DBSPACETEMP environment variable, root dbspace, dbspace where the database was created, DBSPACETEMP onconfig parameter.
D. DBSPACETEMP environment variable, DBSPACETEMP onconfig parameter, dbspace where the database was created, root dbspace.
正解：D
質問 2：
Which SQL Administration API command will merge non-contiguous table extents?
A. shrink
B. table repack
C. defragment
D. merge extents
正解：C
質問 3：
Which two statements are true for onbar only but not for ontape? (Choose two.)
A. It can back up to or restore from cloud storage.
B. It can restart a restore from the place it failed.
C. It can restore data to a given point in time (PIT).
D. It can execute an external backup and restore.
E. It can apply external programs using filters.
正解：B,C
質問 4：
How is the DBSSO group determined on a Unix system with role separation?
A. It is always the group informix.
B. It is the group that owns $INFORMIXDIR/dbssodir.
C. It is set using the onsecurity command line tool.
D. It is the group specified in the DBSSO onconfig parameter.
正解：B
質問 5：
Which statement about in-place migration is true?
A. In-place migration requires that the DBA copy the database schema, user data, and
user objects from the older version to the newer version of Informix.
B. In-place migration is possible when an Informix instance is migrated from an older version of Informix on the same operating system.
C. In-place migration is possible when an Informix instance is migrated from a non-Informix database management system.
D. In-place migration is possible when an Informix instance is migrated from an older version of Informix on a different operating system.
正解：B
質問 6：
When a SELECT statement is executed which statement is true?
A. If COMMITTED READ isolation is in place then the SELECT will never encounter any locking errors.
B. If the SELECT is part of an UPDATE cursor then the database server will place an exclusive lock on the entire dataset.
C. The number and duration of the locks is dependent on the ISOLATION LEVEL.
D. Within a transaction the database server will place row or page locks on a nonlogging table.
正解：C
質問 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
Given the following SQL command where the DBSPACETEMP onconfig and environment variables are set to valid dbspaces:
create temp table mytemp (columns) with no log;
in what order will the instance evaluate where to place this table?
A. DBSPACETEMP onconfig parameter variable, root dbspace, dbspace where the database was created, DBSPACETEMP environment variable.
B. DBSPACETEMP onconfig parameter variable, DBSPACETEMP environment variable,
root dbspace, dbspace where the database was created.
C. DBSPACETEMP environment variable, root dbspace, dbspace where the database was created, DBSPACETEMP onconfig parameter.
D. DBSPACETEMP environment variable, DBSPACETEMP onconfig parameter, dbspace where the database was created, root dbspace.
正解：D
質問 2：
Which SQL Administration API command will merge non-contiguous table extents?
A. shrink
B. table repack
C. defragment
D. merge extents
正解：C
質問 3：
Which two statements are true for onbar only but not for ontape? (Choose two.)
A. It can back up to or restore from cloud storage.
B. It can restart a restore from the place it failed.
C. It can restore data to a given point in time (PIT).
D. It can execute an external backup and restore.
E. It can apply external programs using filters.
正解：B,C
質問 4：
How is the DBSSO group determined on a Unix system with role separation?
A. It is always the group informix.
B. It is the group that owns $INFORMIXDIR/dbssodir.
C. It is set using the onsecurity command line tool.
D. It is the group specified in the DBSSO onconfig parameter.
正解：B
質問 5：
Which statement about in-place migration is true?
A. In-place migration requires that the DBA copy the database schema, user data, and
user objects from the older version to the newer version of Informix.
B. In-place migration is possible when an Informix instance is migrated from an older version of Informix on the same operating system.
C. In-place migration is possible when an Informix instance is migrated from a non-Informix database management system.
D. In-place migration is possible when an Informix instance is migrated from an older version of Informix on a different operating system.
正解：B
質問 6：
When a SELECT statement is executed which statement is true?
A. If COMMITTED READ isolation is in place then the SELECT will never encounter any locking errors.
B. If the SELECT is part of an UPDATE cursor then the database server will place an exclusive lock on the entire dataset.
C. The number and duration of the locks is dependent on the ISOLATION LEVEL.
D. Within a transaction the database server will place row or page locks on a nonlogging table.
正解：C
質問 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
益子** -
問題集は内容も充実していて、C2090-919試験の範囲はしっかり網羅されているという印象です。昨日合格いたしました。お礼言いに来ました。