A2090-619無料問題集「IBM Assessment: Informix Server 12.10 Assessment」

質問 1

Given the following:

How many locks will be used on tab1 to run the query?

（A）1

（B）2

（C）Depends on the number of index pages accessed

（D）0

正解：D 解答を投票する

質問 2

Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3;
CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?

（A）The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.

（B）The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

（C）The temp table will be created in root dbspace.

（D）The temp table will be created in datadbs1.

正解：C 解答を投票する

質問 3

What are two requirements for the "ifxclone" utility? (Choose two.)

（A）Both the source and target servers must use the same type of disk space (raw or cooked).

（B）Only one server clone process can occur at a time.

（C）All databases must use logging.

（D）The source server must be a secondary server.

（E）Both the source and target servers must be part of a trusted network environment.

正解：B、E 解答を投票する

質問 4

When KAIO is available and raw disk is used, which statement is true?

（A）Logical Log IO is performed by the KAIO VP.

（B）Logical Log IO is performed by the LIO VP.

（C）Physical Log IO is performed by the CPU VP.

（D）Physical Log IO is performed by the PIO VP.

正解：C 解答を投票する

質問 5

The DBA updated the uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands:The DBA updated the ?uto_crsd?Scheduler task in the
SYSADMIN database with the following SQL commands: UPDATE ph_task SET tk_enable
= ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name =
? uto_crsd? UPDATE ph_threshold SET value = ?WHERE name =
UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name =
? UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name =
UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name =
? UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?

（A）Do not compress, repack, shrink and defragment any table with more than 5000 rows.

（B）Compress, repack and shrink tables with more than 5000 uncompressed rows.

（C）Compress and defragment tables with more than 5000 uncompressed rows.

（D）Compress all tables with less than 5000 rows.

正解：B 解答を投票する

質問 6

Which object can be compressed?

（A）detached b-tree index

（B）dictionary table

（C）attached b-tree index

（D）temporary table

正解：A 解答を投票する

質問 7

Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

（A）VP_MEMORY_CACHE_KB

（B）DBUPSPACE

（C）DS_POOLSIZE

（D）DS_NONPDQ_QUERY_MEM

正解：D 解答を投票する

質問 8

Which statement is true for starting Connection Manager?

（A）Only user root and informix.

（B）Any user of the DBSA group.

（C）Only a user of the DBSA group with privilege to connect to the sysadmin database.

（D）Any user who is granted privileges to connect to the sysadmin database.

正解：C 解答を投票する

質問 9

Which feature can be enabled in Informix?

（A）Automatic addition of message log files.

（B）Automatic extension of storage spaces.

（C）Automatic addition of a CPU VP.

（D）Automatic addition of an ADM VP.

正解：B 解答を投票する

質問 10

Which statement accurately describes the selective row-level auditing feature in Informix?

（A）Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.

（B）Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.

（C）Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

（D）Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.

正解：D 解答を投票する

A2090-619 無料問題集「IBM Assessment: Informix Server 12.10 Assessment」

弊社を連絡する

関連リンク

トップ試験