IBM C2090-919 - Informix 11.70 System Administrator Exam
Page: 1 / 25
Total 123 questions
Question #1 (Topic: Topic 1)
Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based
on remaining free space?
on remaining free space?
A. SP_AUTOGROW
B. SP_THRESHOLD
C. SP_AUTOEXPAND
D. SP_CHUNKEXTEND
Answer: B
Question #2 (Topic: Topic 1)
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");
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. Rows will be moved to the beginning of table.
C. Given sufficient resources the number of extents in the table will be reduced.
D. Free space at the end of the table will be released to the dbspace for other tables to use.
E. The table will be locked preventing inserts from happening for the duration of the commands.
Answer: B,C
Question #3 (Topic: Topic 1)
Which sysmaster table can be queried to find the logging status of a database?
A. sysdb
B. sysdblog
C. sysdatabases
D. sysdblogstatus
Answer: C
Question #4 (Topic: Topic 1)
To maximize the performance of your OnBar backup and recovery operations, what should
you do?
you do?
A. Use a commercial storage manager.
B. Use the bundled Informix Storage Manager (ISM).
C. Use a combination of disk-based and tape-based backup devices.
D. Use separate storage devices for instance spaces and logical logs.
Answer: D
Question #5 (Topic: Topic 1)
Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will
temporary tables be created by default? (Choose three.)
temporary tables be created by default? (Choose three.)
A. The root dbspace.
B. The users' home directory.
C. The $INFORMIXDIR/tmp directory.
D. The dbspace in which the active database was created.
E. The /tmp directory or PSORT_DBTEMP.
Answer: A,D,E
