1034 お客様のコメント
質問 1：
Which utilities CANNOT be used to migrate an Informix instance from one hardware vendor to a different hardware vendor?
A. dbacess unload and dbload
B. High Performance Loader (HPL)
C. onunload and onload
D. dbexport and dbimport
正解：C
質問 2：
Which statement about automatic space management is true?
A. Mirrored and unmirrored spaces can be extended.
B. The time interval for low storage space checks is not user configurable.
C. Only unmirrored spaces can be extended.
D. Spaces cannot be extended manually.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3：
Which statement about the scope of UPDATE STATISTICS is true?
A. If the FOR TABLE keywords are specified with a table but without specifying a list of columns, the database server will not recalculate distributions on all of the columns of the specified table.
B. If the FOR PROCEDURE specification, Table and Column Scope, and Resolution clauses are NOT included, then the statistics are updated for every table and SPL routine in the current database.
C. If the FOR TABLE keywords are used without specifying the name or synonym of a table, the database will not recalculate distributions for any table in the current database.
D. If the FOR PROCEDURE keywords are included but the name of any SPL routine is not specified, an error will be returned.
正解：B
解説: (Pass4Test メンバーにのみ表示されます)
質問 4：
What statement about users accessing a Flexible Grid is true?
A. Only user informix can execute commands on a Flexible Grid.
B. Commands can only be executed from the node on which the Flexible Grid was created.
C. Users have to be authorized to execute Flexible Grid commands.
D. Every user can execute commands on the Flexible Grid.
正解：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：
Which $ONCONFIG parameter must be set enable parallel OnBar backup operations?
A. BAR_PERFORMANCE
B. BAR_NB_XPORT_COUNT
C. BAR_SIZE_FACTOR
D. BAR_MAX_BACKUP
正解：D
質問 7：
When adding space to the storagepool, which correctly describes the type of storage which may be placed in the storagepool?
A. Cooked file only.
B. Cooked files and Raw devices only.
C. Raw devices only.
D. Cooked files, Raw devices and Directories.
正解：D
質問 8：
Which statement about Informix data compression is true?
A. Compressing data on a primary instance will not compress data on the High-Availability Data Replication (HDR) secondary instance.
B. Compressing data on one Enterprise Replication (ER) node affects the data on the other ER nodes.
C. Compression operations can be executed on a HDR secondary, RS secondary, or SD secondary server.
D. I/O-bound tables, for example, those with bad cache hit ratios, are good candidates for compression.
正解：D
Which utilities CANNOT be used to migrate an Informix instance from one hardware vendor to a different hardware vendor?
A. dbacess unload and dbload
B. High Performance Loader (HPL)
C. onunload and onload
D. dbexport and dbimport
正解：C
質問 2：
Which statement about automatic space management is true?
A. Mirrored and unmirrored spaces can be extended.
B. The time interval for low storage space checks is not user configurable.
C. Only unmirrored spaces can be extended.
D. Spaces cannot be extended manually.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3：
Which statement about the scope of UPDATE STATISTICS is true?
A. If the FOR TABLE keywords are specified with a table but without specifying a list of columns, the database server will not recalculate distributions on all of the columns of the specified table.
B. If the FOR PROCEDURE specification, Table and Column Scope, and Resolution clauses are NOT included, then the statistics are updated for every table and SPL routine in the current database.
C. If the FOR TABLE keywords are used without specifying the name or synonym of a table, the database will not recalculate distributions for any table in the current database.
D. If the FOR PROCEDURE keywords are included but the name of any SPL routine is not specified, an error will be returned.
正解：B
解説: (Pass4Test メンバーにのみ表示されます)
質問 4：
What statement about users accessing a Flexible Grid is true?
A. Only user informix can execute commands on a Flexible Grid.
B. Commands can only be executed from the node on which the Flexible Grid was created.
C. Users have to be authorized to execute Flexible Grid commands.
D. Every user can execute commands on the Flexible Grid.
正解：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：
Which $ONCONFIG parameter must be set enable parallel OnBar backup operations?
A. BAR_PERFORMANCE
B. BAR_NB_XPORT_COUNT
C. BAR_SIZE_FACTOR
D. BAR_MAX_BACKUP
正解：D
質問 7：
When adding space to the storagepool, which correctly describes the type of storage which may be placed in the storagepool?
A. Cooked file only.
B. Cooked files and Raw devices only.
C. Raw devices only.
D. Cooked files, Raw devices and Directories.
正解：D
質問 8：
Which statement about Informix data compression is true?
A. Compressing data on a primary instance will not compress data on the High-Availability Data Replication (HDR) secondary instance.
B. Compressing data on one Enterprise Replication (ER) node affects the data on the other ER nodes.
C. Compression operations can be executed on a HDR secondary, RS secondary, or SD secondary server.
D. I/O-bound tables, for example, those with bad cache hit ratios, are good candidates for compression.
正解：D
外山** -
過去問解説もくわしくて、とても勉強しやすい本でした。これ一冊でなんとかなりそう