IBM Assessment: Informix Server 12.10 Assessment 認定 A2090-619 試験問題:

1. The following message is received: Lock table overflow - user id user32, session id 54.
What action should be taken to prevent this problem in the future?

A) Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.
B) Turn on the AUTO_TUNE configuration parameter.
C) Increase the LOCKS configuration parameter.
D) Run onclean utility to clear the lock table.

2. Which SQL statement is valid to monitor database server sessions?

A) EXECUTE FUNCTION task ("check server","sessions");
B) EXECUTE FUNCTION task ("onstat","-g ses");
C) EXECUTE FUNCTION task ("view sessions","all");
D) EXECUTE FUNCTION task ("check sessions","all");

3. For a query to be processed by the accelerator, the query or query block should meet the certain criteria. Which statement is FALSE?

A) The query or query block must refer to a subset of the tables in the AQT.
B) The query or query block must include at least 2 fact tables.
C) The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.
D) The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

4. Which action can be taken if an instance is down?

A) Warm restore of non-critical storage spaces.
B) Cold restore by onbar using storage space backups taken by ontape on tape devices.
C) A mixed restore using onbar whole system backup and incremental dbspace level backups.
D) A point-in-time mixed restore.

5. Which two statements are true about Enterprise Replication of TimeSeries data types?
(Choose two.)

A) ATS and RIS files must be in XML format.
B) The conflict resolution rule must be always-apply.
C) CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server.
D) The WHERE clause in the participant definition must include a TimeSeries column.
E) The replicate must be a mastered replicate.

質問と回答：