IBM Assessment: System Administrator for Informix Server 11.70 - A2090-919무료 덤프문제 풀어보기

A. High-availability data replication secondary

B. Remote standalone secondary

C. Primary

D. Shared disk secondary

A. VP_MEMORY_CACHE_KB

B. DS_NONPDQ_QUERY_MEM

C. RESIDENT

D. EXTSHMADD

A. The query returns the ordered text form of the specified procedure body.

B. The query returns neither the ordered text nor the ordered compiled form of the specified procedure body.

C. The query returns both ordered text and ordered compiled form of the specified procedure body.

D. The query returns the ordered compiled form of the specified procedure body.

A. NETTYPE

B. FET_BUF_SIZE

C. NS_CACHE

D. NUMFDSERVERS

E. VPCLASS

A. A raw table can be created in a temporary dbspace.

B. Temporary dbspaces can have non-default page sizes.

C. Tables stored in temporary dbspaces are not logged.

D. Temporary dbspaces are not backed up.

A. When the I/O is to raw disk space.

B. When the I/O is to cooked disk space.

C. When the table is too big to fit in the bufferpool.

D. When the DIRECT_IO configuration parameter is set to 1.

E. When doing I/O operations on temporary dbspaces.

A. Enter the CSM name in the onconfig NETTYPE parameter.

B. Enter the CSM name in the sqlhosts file.

C. Set the IFX_ENCCSM onconfig parameter to 1.

D. Set the environment variable ENCCSMCFG to the name of the CSM.

E. Define the CSM in the concsm.cfg configuration file.

A. Only for events with Severity code greater than 1.

B. Only for events with Severity code 1.

C. Only for events with Severity code 5.

D. All events.

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.