IBM Assessment: System Administrator for Informix Server 11.70 認定 A2090-919 試験問題:

1. Under which condition can table fragments NOT be eliminated during query processing?

A) Tables with non-overlapping fragments and an equality query predicate.
B) Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.
C) Tables with round-robin distribution scheme and a range query predicate.
D) Tables with non-overlapping fragments on a single column and a range query predicate.

2. The user 'guest' connected to a local database world@lsys and wants to execute the following query:

What two permissions does the user 'guest' need to access the remote table? (Choose two.)

A) User 'guest' must have CONNECT permission on 'globe'
B) User 'guest' must have SELECT permission on 'globe@rsys:position'
C) User 'guest' must have RESOURCE permission on 'world@lsys'
D) User 'guest' must have CONNECT permission on 'globe@rsys:sadm.position'
E) User 'guest' must have SELECT permission on 'globe'

3. 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) Fragments of a table will be combined.
B) Free space at the end of the table will be released to the dbspace for other tables to use.
C) Given sufficient resources the number of extents in the table will be reduced.
D) Rows will be moved to the beginning of table.
E) The table will be locked preventing inserts from happening for the duration of the commands.

4. Why do automatic checkpoints cause the database server to trigger more frequent
checkpoints?

A) To avoid transaction blocking during checkpoints.
B) To avoid LRU flushes.
C) To ensure the buffer pool is always available.
D) To ensure the onstat -g ckp report is accurate.

5. Which onstat command returns an accurate free count of blobspace pages?

A) onstat -d
B) onstat -d blobinfo
C) onstat -d update
D) onstat -g blb

質問と回答：