664 お客様のコメント
質問 1：
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
質問 2：
When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.)
execute function sysadmin:task("defragment table","customer"); execute function sysadmin:task("table repack", "customer");
A. The table will be locked preventing inserts from happening for the duration of the commands.
B. Free space at the end of the table will be released to the dbspace for other tables to use.
C. Rows will be moved to the beginning of table.
D. Given sufficient resources the number of extents in the table will be reduced.
E. Fragments of a table will be combined.
正解：C,D
質問 3：
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
質問 4：
Which two actions will occur when the following command is executed? (Choose two.) UPDATE STATISTICS HIGH AUTO
A. Update statistics will run high on the table named AUTO.
B. Update statistics will run high only on columns which meet the STATSCHANGE threshold.
C. Update statistics will run high only after the optimizer decides the statistics are too old.
D. Stored Procedures will be recompiled.
E. Update statistics will run high only on the first column of an index.
正解：B,D
質問 5：
Which of the following privileges is NOT valid for a table fragment?
A. INSERT
B. UPDATE
C. ALL
D. CREATE INDEX
正解：D
質問 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 option would be used with "cdr define replicate" to create a shadow replicate?
A. --mirrors
B. --synchronize
C. --backup
D. --shadow
正解：A
質問 8：
Under which condition can table fragments NOT be eliminated during query processing?
A. Tables with round-robin distribution scheme and a range query predicate.
B. Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.
C. Tables with non-overlapping fragments and an equality query predicate.
D. Tables with non-overlapping fragments on a single column and a range query predicate.
正解：A
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
質問 2：
When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.)
execute function sysadmin:task("defragment table","customer"); execute function sysadmin:task("table repack", "customer");
A. The table will be locked preventing inserts from happening for the duration of the commands.
B. Free space at the end of the table will be released to the dbspace for other tables to use.
C. Rows will be moved to the beginning of table.
D. Given sufficient resources the number of extents in the table will be reduced.
E. Fragments of a table will be combined.
正解：C,D
質問 3：
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
質問 4：
Which two actions will occur when the following command is executed? (Choose two.) UPDATE STATISTICS HIGH AUTO
A. Update statistics will run high on the table named AUTO.
B. Update statistics will run high only on columns which meet the STATSCHANGE threshold.
C. Update statistics will run high only after the optimizer decides the statistics are too old.
D. Stored Procedures will be recompiled.
E. Update statistics will run high only on the first column of an index.
正解：B,D
質問 5：
Which of the following privileges is NOT valid for a table fragment?
A. INSERT
B. UPDATE
C. ALL
D. CREATE INDEX
正解：D
質問 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 option would be used with "cdr define replicate" to create a shadow replicate?
A. --mirrors
B. --synchronize
C. --backup
D. --shadow
正解：A
質問 8：
Under which condition can table fragments NOT be eliminated during query processing?
A. Tables with round-robin distribution scheme and a range query predicate.
B. Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.
C. Tables with non-overlapping fragments and an equality query predicate.
D. Tables with non-overlapping fragments on a single column and a range query predicate.
正解：A
山田** -
A2090-919の問題集には解説があるので時間短縮できて使いやすいです。問題集を購入させていただきました。今回もいい結果が出そう。