최신 A2090-619 무료덤프 - IBM Assessment: Informix Server 12.10 Assessment

문제1

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

A. $ONCONFIG

B. /etc/hosts.equiv

C. /etc/services

D. sqlhosts

정답: B

문제2

Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured?
(Choose two.)

A. Total number of available semaphores.

B. Lower-boundary address for shared memory.

C. Memory page size.

D. Maximum operating-system shared-memory segment size.

E. Total memory presented to the operating system.

정답: B,D

문제3

Where must the HA_FOC_ORDER configuration parameter be set?

A. The SDS secondary only.

B. The HDR secondary only.

C. Any server in the cluster.

D. The primary server only.

정답: D

문제4

Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

A. STATAUTO

B. STATFORCE

C. STATCHANGE

D. FORCE AUTO

정답: C

문제5

Which statement is FALSE about Informix Automatic checkpoint Feature?

A. Automatic checkpoints cause less logical log activity.

B. Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm or onmode -wf.

C. Automatic checkpoints try to avoid transaction blocking.

D. Automatic checkpoints cause the database server to trigger more frequent checkpoints.

정답: A

문제6

Which is a valid Pluggable Authentication Module (PAM) mode in Unix?

A. Password mode

B. Client mode

C. Login mode

D. Server mode

정답: A

문제7

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

A. Copy external files to grid servers.

B. Install Informix products.

C. Setup replication automatically in a grid.

D. Modify replication server attributes for grid servers.

E. Start Informix servers in a grid.

정답: A,C

문제8

Which statement is FALSE regarding SBSPACES?

A. They are recoverable.

B. They do not obey transaction isolation modes.

C. Smart large objects within table rows are not required to be retrieved in one statement.

D. They have read, write, and seek properties similar to a standard UNIX file.

정답: B

문제9

Which OpenAdmin Tool feature is used to analyze the state of the Informix database server and can alert the DBA through email?

A. SQL Toolbox

B. Server Administration

C. Performance Analysis

D. Health Advisor

정답: D

문제10

Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer
(customer_num); Which catalog table data is NOT updated?

A. sysdistrib

B. syscolumns

C. systables

D. sysindexes

정답: A

최신 A2090-619 무료덤프 - IBM Assessment: Informix Server 12.10 Assessment

우리와 연락하기

유용한 링크

최신 업데이트