IBM C2090-619 - IBM Informix 12.10 System Administrator Exam
Page: 2 / 26
Total 130 questions
Question #6 (Topic: )
Which Informix utility can be used to display contents of logical-log files, either from disk or
from backup?
from backup?
A. onlog
B. onclean
C. ondblog
D. onspaces
Answer: A
Question #7 (Topic: )
Which statement about DataBlade modules is true?
A. All DataBlades located in the $INFORMIXDIR/extend are automatically registered.
B. All built-in extensions are automatically registered when the extension is first accessed.
C. All built-in extensions are automatically registered each time the database sever is started.
D. All built-in extensions are automatically registered when the database server is first initialized.
Answer: B
Question #8 (Topic: )
In which table can you find a history of all SQL Administration API functions executed in the
last 30 days?
last 30 days?
A. sysadmin:admin_history
B. sysmaster:admin_history
C. sysadmin:command_history
D. sysmaster:command_history
Answer: C
Question #9 (Topic: )
The purge policy CANNOT be executed for a rolling window table utilizing which method?
A. By calling the syspurge function.
B. By the purge_tables task of the Scheduler.
C. By setting up the server to automatically run the purge policy.
D. By running ALTER FRAGMENT with the PURGE NOW predicate.
Answer: D
Question #10 (Topic: )
The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement
CANNOT define a purging policy on a table that has which two attributes? (Choose two.)
CANNOT define a purging policy on a table that has which two attributes? (Choose two.)
A. The table has a ROWID shadow column.
B. The table has a Fragment By Range index.
C. The table has a Unique Key being used by ER.
D. The Fragment Key is defined with multiple columns.
E. The Primary Key for the table is referenced by a foreign key constraint.
Answer: A,E
