[2026] IBM Assessment: Informix Server 12.10 Assessment

문제1

Which option maximizes performance in an Informix Warehouse (DSS) environment?

A. Higher value of PHYSBUFF.

B. Higher value of LOGBUFF.

C. Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.

D. SHMTOTAL set to 0 to allow Informix to access all available physical memory.

정답: D

문제2

Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

A. AUTO_CONFIG

B. AUTO_TUNE

C. AUTO_ENABLE

D. AUTO_PERF

정답: B

문제3

When configuring Informix server for DRDA connection, which statement is true?

A. The database server name should correspond to either the DBSERVERNAME or the
DBSERVERALIASES onconfig parameter.

B. The database server name for DRDA connection must correspond to the
DBSERVERALIASES onconfig parameter.

C. The database server name for DRDA connection must correspond to the
DBSERVERNAME onconfig parameter.

D. The connection protocol must be drsoctcp.

정답: B

문제4

Which two tasks can be performed through an Informix Grid? (Choose two.)

A. Start Informix servers in a grid.

B. Setup replication automatically in a grid.

C. Copy external files to grid servers.

D. Install Informix products.

E. Modify replication server attributes for grid servers.

정답: B,C

문제5

Which approach is always valid when migrating data across differing hardware and operating system architectures?

A. dbexport source system then dbimport into target.

B. onunload the source to tape and onload the tape to the target.

C. ontape backup from source then restore backup onto target.

D. Set up HDR primary and secondary between source and target.

정답: A

문제6

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

A. CLEANERS

B. RA_PAGES

C. CKPTINTVL

D. SHMVIRTSIZE

정답: A

문제7

Which statement is true about log salvaging?

A. ontape cannot perform salvage of logs.

B. Log salvaging cannot be avoided if onbar is used for restore.

C. Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.

D. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.

정답: D

문제8

How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

A. Use the RETAIN UPDATE LOCKS clause with isolation level.

B. Use the 'Committed Read' isolation level.

C. Use the SET TRANSACTION command to with SERIALIZABLE clause.

D. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.

정답: A

문제9

Assuming network connectivity between two Informix instances, which file may need additional configuration to allow distributed queries?

A. /etc/hosts.equiv

B. $ONCONFIG

C. sqlhosts

D. /etc/services

정답: A

문제10

What is the purpose of the ifx_getMartStat() function?

A. To display statistics about the workers and coordinators defined for the accelerator.

B. To display status information about the data mart.

C. To display update statistics information about the data mart and its tables.

D. To display status information about the Informix Warehouse Accelerator and all the data marts.

정답: B

IBM Assessment: Informix Server 12.10 Assessment - A2090-619무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트