최신 C2090-619 무료덤프 - IBM Informix 12.10 System Administrator

문제1

Which two parameters must be set to a valid value before starting a Shared Disk (SD)
Secondary server? (Choose two.)

A. SDS_LOGCHECK

B. SDS_TEMPDBS

C. SDS_TIMEOUT

D. SDS_PAGING

E. SDS_ALTERNATE

정답: B,D

문제2

Which Informix utility is used to print information about runtime statistics for all threads in the server?

A. onstat -g rea

B. onstat -g sta

C. onstat -g act

D. onstat -g cpu

정답: D

문제3

The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement
CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

A. The table has a ROWID shadow column.

B. The table has a Fragment By Range index.

C. The table has a Unique Key being used by ER.

D. The Fragment Key is defined with multiple columns.

E. The Primary Key for the table is referenced by a foreign key constraint.

정답: A,E

문제4

The purge policy CANNOT be executed for a rolling window table utilizing which method?

A. By setting up the server to automatically run the purge policy.

B. By calling the syspurge function.

C. By the purge_tables task of the Scheduler.

D. By running ALTER FRAGMENT with the PURGE NOW predicate.

정답: D

문제5

Which feature can be enabled in Informix?

A. Automatic addition of a CPU VP.

B. Automatic addition of message log files.

C. Automatic addition of an ADM VP.

D. Automatic extension of storage spaces.

정답: D

문제6

Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?

A. onsmsync

B. ontape -exp

C. onbar -E

D. dbexport

정답: A

문제7

Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

A. FAILOVER_TX_TIMEOUT

B. DELAY_APPLY

C. LOG_INDEX_BUILDS

D. HDR_TXN_SCOPE

정답: D

문제8

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

A. OPT_GOAL

B. OPTMSG

C. OPTOFC

D. OPTCOMPIND

정답: A

문제9

During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?

A. System global, user local shell

B. Onconfig file, user local shell, system global

C. User local shell, system global

D. System global, user local shell, onconfig file

정답: B

문제10

Which two statements are true about blobspace? (Choose two.)

A. The TEXT or BYTE objects that are assigned to a blobspace are physically logged.

B. A newly created blobspace is immediately available for storage of TEXT or BYTE data.

C. The database server writes data stored in a blobspace directly to disk without passing it through the bufferpool.

D. A blobspace is a logical storage unit that stores only TEXT and BYTE data.

E. The TEXT or BYTE objects are stored in the logical log files.

정답: C,D

최신 C2090-619 무료덤프 - IBM Informix 12.10 System Administrator

우리와 연락하기

유용한 링크

최신 업데이트