IBM Informix 11.70 System Administrator - 000-919 Exam Practice Test

A. The userthread is waiting for a thread with a higher priority.

B. The userthread is waiting for end user I/O to complete.

C. The userthread is waiting for a thread to yield a cpu vp.

D. The userthread is waiting on a condition.

A. Use the bundled Informix Storage Manager (ISM).

B. Use a combination of disk-based and tape-based backup devices.

C. Use separate storage devices for instance spaces and logical logs.

D. Use a commercial storage manager.

A. UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable.

B. UPDATE STATISTICS HIGH scans the entire table.

C. An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE.

D. Data distributions are updated every time UPDATE STATISTICS LOW is executed.

A. DBSA

B. DBA

C. DBSSO

D. DBSECADM

A. It can restart a restore from the place it failed.

B. It can back up to or restore from cloud storage.

C. It can restore data to a given point in time (PIT).

D. It can execute an external backup and restore.

E. It can apply external programs using filters.

A. ADM

B. BTS

C. CPU

D. CSM

A. onunload and onload

B. dbacess unload and dbload

C. dbexport and dbimport

D. High Performance Loader (HPL)

A. By limiting the size of dbspaces.

B. By removing specific product features.

C. By removing all free space at the end of a chunk.

D. By removing specific databases.

A. The DBSA can control the access to tables at a row level using security labels.

B. Mapped users are allowed to run with multiple names.

C. The DBSA can grant database server access to externally authenticated users with no local account.

D. Mapped users cannot execute distributed operations.

A. SET EXPLAIN output.

B. onstat -D.

C. onstat -g ath.

D. onstat -l.

E. onstat -p.