IBM Assessment: System Administrator for Informix Server 11.70 認定 A2090-919 試験問題:

1. If the DYNAMIC_LOGS onconfig parameter is set to 1 and logical log backups are not occurring, what will happen in the instance when the last logical-log file fills?

A) The database server will automatically execute a checkpoint and flush the oldest update to disk.
B) The database server will stop processing, then start an automatic backup of the logical-log file and resume normal processing once the automatic back up of the logical-log files is completed.
C) The instance suspends all processing until the next logical-log file is manually added.
D) The database server will make use of any logical-log file available regardless of whether the available file is in sequence or not.

2. Which role can create, alter, or delete trusted context objects?

A) DBSA
B) DBSSO
C) DBSECADM
D) DBA

3. Which two corrective actions may be taken if following message is logged in the online message log during a failed attempt to bring an instance online? (Choose two)
18:15:44
Size of resident + virtual segments 100000KB + 60000KB > 150000KB
18:15:44
total allowed by configuration parameter SHMTOTAL

A) Decrease SHMBASE
B) Decrease buffer pool size
C) Increase SHMTOTAL
D) Decrease SHMADD
E) Increase SHMVIRTSIZE

4. Which two objects are NOT included in a backup? (Choose two.)

A) Basic text search indexes stored in external dbspaces
B) External tables
C) Indexes
D) Simple blob data stored in simple blobspaces
E) Tables

5. Which list fragmentation statement is true?

A) It allows overlapping fragments.
B) It can only be used for numeric columns.
C) It allows a fragment to be defined as a remainder.
D) It cannot be used for indexes.

質問と回答：