Online Access Free A2090-919 Practice Test

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

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

What does the following SQL statement do? execute function task("reset sysadmin", "admindbs");

• A.Turns the whole Database Scheduler off and finally drops sysadmin database.
• B.Locks sysadmin database in exclusive mode and recreates it in dbspace admindbs.
• C.Renames sysadmin database to admindbs.
• D.Purges all "mon_*" tables in sysadmin database as user admindbs.

Given the following:

IBM 000-919 : Practice Test

• A.Update one row and insert two rows.
• B.Update two rows and insert one row.
• C.Return a 26095 error - Cannot update or delete a row twice in a MERGE statement.
• D.Update three rows.

To maximize the performance of your OnBar backup and recovery operations, what should you do?

• A.Use the bundled Informix Storage Manager (ISM).
• B.Use a commercial storage manager.
• C.Use a combination of disk-based and tape-based backup devices.
• D.Use separate storage devices for instance spaces and logical logs.

Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?

• A.SP_THRESHOLD
• B.SP_CHUNKEXTEND
• C.SP_AUTOGROW
• D.SP_AUTOEXPAND