IBM Assessment: System Administrator for Informix Server 11.70 - A2090-919 Exam Practice Test

A. INSERT B. ALL C. CREATE INDEX D. UPDATE

A. cdr set onconfig B. cdr define onconfig C. cdr tune onconfig D. cdr change onconfig

A. When AIO is not available. B. When the KAIOON parameter in ONCONFIG file is set to 1. C. When the operating system supports it. D. When the I/O is to buffered file chunks. E. When the I/O is to raw disk space.

A. If the FOR TABLE keywords are specified with a table but without specifying a list of columns, the database server will not recalculate distributions on all of the columns of the specified table. B. If the FOR TABLE keywords are used without specifying the name or synonym of a table, the database will not recalculate distributions for any table in the current database. C. If the FOR PROCEDURE keywords are included but the name of any SPL routine is not specified, an error will be returned. D. If the FOR PROCEDURE specification, Table and Column Scope, and Resolution clauses are NOT included, then the statistics are updated for every table and SPL routine in the current database.

A. The table definitions without owner names. B. The onspaces commands to re-create your systems' dbspaces. C. The schemas of remote databases. D. The database logging mode.

A. Increase the size of a chunk. B. Increase the size of a storage space. C. Increase the size of the logical logs. D. Increase the size of the physical log.