C2090-619 Online Practice Questions and Answers

Which configuration parameter locks the resident and virtual segments of shared memory in operating-system physical memory?

A. SHMSEG

B. SHMBASE

C. RESIDENT

D. INFORMIXSHMLCK

Which configuration parameter can be set to quickly return rows to a user while a query continues processing?

A. OPTOFC

B. OPTMSG

C. OPT_GOAL

D. OPTCOMPIND

Which type of device does Primary Storage Manager support?

A. File

B. Tape

C. Directory

D. Named pipe

Which action can be taken if an instance is down?

A. A point-in-time mixed restore.

B. Warm restore of non-critical storage spaces.

C. Cold restore by onbar using storage space backups taken by ontape on tape devices.

D. A mixed restore using onbar whole system backup and incremental dbspace level backups.

Which statement is NOT true about a Storage Pool?

A. You can create multiple storage pools per database server.

B. You can add, modify, delete, and purge storage pool entries.

C. Priorities can be used to determine space allocation order.

D. It consists of any combination of a raw device, a cooked file, or a directory.

To potentially return unused extent pages to the chunk free list, an Informix administrator would execute which storage optimization operation?

A. Shrink

B. Repack

C. Compress

D. Defragment

Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

A. cdr start

B. cdr sync

C. cdr realize

D. cdr remaster

Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

A. CKPTINTVL

B. RA_PAGES

C. CLEANERS

D. SHMVIRTSIZE

Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

A. DBUPSPACE

B. DS_POOLSIZE

C. VP_MEMORY_CACHE_KB

D. DS_NONPDQ_QUERY_MEM

Which command line utility does NOT have the equivalent functionality using the SQL Administration API?

A. oninit

B. onmode

C. onspaces

D. onparams