IBM C2090-544 Online Practice Questions and Exam Preparation

IBM C2090-544 Online Questions & Answers

• Question 11:

  An active partitioned instance named DB2INST1 uses the following db2nodes.cfg file:

  1 server1 0 2 server1 1 3 server1 2 4 server1 3

  The following command is issued to add a new database partition:

  db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4 Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?

  A. Partitions 1, 2, 3, 4, and 5 are active and available.
  B. Partitions 1, 2, 3, and 4 are active, but partition 5 is not.
  C. All partitions are active but partition 5 is not available until a temporary table space is defined.
  D. DB2 responds to the configuration change by stopping all partitions.
  B. Partitions 1, 2, 3, and 4 are active, but partition 5 is not.

• Question 12:

  Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?

  A. It is recommended to set this variable only when the Self-Tuning Memory Manager (STMM) is disabled.
  B. It is recommended to set this variable only when using STMM, when DATABASE_MEMORY is set to AUTOMATIC, and if insufficient system memory problems are occurring.
  C. It is recommended that this variable be enabled at all times in order to prevent DB2 from taking too much physical memory.
  D. It is recommended that this variable be used to set the maximum percentage of memory that DB2 can use on the system.
  B. It is recommended to set this variable only when using STMM, when DATABASE_MEMORY is set to AUTOMATIC, and if insufficient system memory problems are occurring.

• Question 13:

  Which command will prevent prefetching during crash recovery?

  A. db2set DB2_AVOID_PREFETCH=OFF
  B. db2set DB2_AVOID_PREFETCH=ON
  C. db2set DB2_RECOVERY_PREFETCHING=NO
  D. db2set DB2_RECOVERY_PREFETCHING=YES
  B. db2set DB2_AVOID_PREFETCH=ON

• Question 14:

  A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

  A. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.
  B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.
  C. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.
  D. The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.
  B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.

• Question 15:

  Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility?

  A. UTIL_HEAP_SZ and STAT_HEAP_SZ
  B. LOAD_HEAP_SZ and DATABASE_MEMORY
  C. LOAD_HEAP_SZ and STAT_HEAP_SZ
  D. UTIL_HEAP_SZ and DATABASE_MEMORY
  D. UTIL_HEAP_SZ and DATABASE_MEMORY

• Question 16:

  Which method should be used to construct an LBAC security component that represents a person's level of trust?

  A. SET
  B. TREE
  C. ARRAY
  D. ORDER
  C. ARRAY

• Question 17:

  At which two levels can events be audited? (Choose two.)

  A. Instance level
  B. Database level
  C. Server level
  D. Operating System level
  E. Node level
  A. Instance level
  B. Database level

• Question 18:

  When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?

  A. It terminates immediately.
  B. It remains active as long as the MAXAGENTS setting is not exceeded.
  C. It is placed in the agent pool if the connection is terminated.
  D. It automatically releases the database connection and returns to the pool.
  C. It is placed in the agent pool if the connection is terminated.

• Question 19:

  Which statement is true about clustering indexes in a partitioned database?

  A. The partitioning key column(s) should be added to the clustering index with the INCLUDE option.
  B. The clustering index column(s) should be suffixed by the partitioning key column(s).
  C. The clustering index column(s) should be prefixed by the partitioning key column(s).
  D. The partitioning key column(s) should be added immediately after the column in the clustering index with the highest cardinality.
  C. The clustering index column(s) should be prefixed by the partitioning key column(s).

• Question 20:

  Your UNIX system administrator has indicated that there appears to be a lot of I/O wait time associated with your database, which is stored in a 7+p RAID array. An investigation reveals the following information:

  DB2_PARALLEL_IO=*

  Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of 16K, an extent size of 32, and a prefetch size of 64.

  Which setting would optimize I/O for the largest table?

  A. DB2_PARALLEL_IO=7:64
  B. DB2_PARALLEL_IO=7:7
  C. DB2_PARALLEL_IO=7:16
  D. DB2_PARALLEL_IO=7:32
  B. DB2_PARALLEL_IO=7:7