최신 Certified Administrator A2090-919 무료샘플문제:
1. What does the ovbuff field of an onstat -p output show?
A) The number of times that any buffer was overwritten.
B) The number of times that a buffer was read.
C) The number of times the instance ran out of free buffers.
D) The number of times a buffer was extended.
2. Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?
A) SP_CHUNKEXTEND
B) SP_THRESHOLD
C) SP_AUTOEXPAND
D) SP_AUTOGROW
3. Which of the following gives a good initial estimate for the physical log size?
A) 110% of the logical log space.
B) 110% the default buffer pool.
C) 110% of rootdbs.
D) 110% of combined buffer pool.
4. Which two actions will occur when the following command is executed? (Choose two.) UPDATE STATISTICS HIGH AUTO
A) Update statistics will run high on the table named AUTO.
B) Update statistics will run high only on the first column of an index.
C) Update statistics will run high only after the optimizer decides the statistics are too old.
D) Stored Procedures will be recompiled.
E) Update statistics will run high only on columns which meet the STATSCHANGE threshold.
5. Which statement about in-place migration is true?
A) In-place migration requires that the DBA copy the database schema, user data, and
user objects from the older version to the newer version of Informix.
B) In-place migration is possible when an Informix instance is migrated from an older version of Informix on the same operating system.
C) In-place migration is possible when an Informix instance is migrated from a non-Informix database management system.
D) In-place migration is possible when an Informix instance is migrated from an older version of Informix on a different operating system.
질문과 대답:
질문 # 1 정답: C | 질문 # 2 정답: B | 질문 # 3 정답: D | 질문 # 4 정답: D,E | 질문 # 5 정답: B |