IBM Assessment: System Administrator for Informix Server 11.70 - A2090-919 模擬練習
Given the following customer table:
正解: D
Which statement about automatic space management is true?
正解: B
Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?
正解: A
Which sbspaces statement is FALSE?
正解: A
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");
execute function sysadmin:task("defragment table","customer"); execute function sysadmin:task("table repack", "customer");
正解: A,B
What two onconfig parameters will help improve performance of new network connections? (Choose two.)
正解: A,B
What does this user-defined task/sensor do?
IBM 000-919 : Practice Test
IBM 000-919 : Practice Test
正解: A
Which list fragmentation statement is true?
正解: A
Which statement about auditing is NOT true?
正解: B
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?
create temp table mytemp (columns) with no log;
in what order will the instance evaluate where to place this table?
正解: C