IBM C2090-311 Online Practice Questions and Exam Preparation

IBM C2090-311 Online Questions & Answers

• Question 21:

  Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?

  A. db2iupdt-a
  B. db2iupdt-update
  C. db2iupdt-commit_level
  D. db2iupdt-online_update
  B. db2iupdt-update

• Question 22:

  When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?

  A. When crash recovery is occurring on the standby cluster.
  B. When all the log streams are in peer or assisted remote catchup state.
  C. When the primary database is not connected to the standby database.
  D. All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.
  D. All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.

• Question 23:

  What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to populate a column-organized table and a statistics profile does not exist?

  A. A warning is returned and no statistics are collected.
  B. An error is returned and the table is placed in "load pending" state.
  C. A statistics profile is automatically generated before the load is allowed to continue.
  D. The Load utility uses the same RUNSTATS command options as those used during an automatic runstats operation.
  C. A statistics profile is automatically generated before the load is allowed to continue.

• Question 24:

  Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?

  A. EHL is enabled by default in DB2 10.5 pureScale environments.
  B. There are three EHL states available: SHARED, DIRECT_ACCESS and NONSHARED.
  C. Only regular tables, temporary tables, and non-partitioned indexes can take advantage of EHL.
  D. EHL is designed to improve DB2 pureScale performance by avoiding CF communications for tables that are accessed from only one member.
  A. EHL is enabled by default in DB2 10.5 pureScale environments.

• Question 25:

  Which statement about column-organized tables is true?

  A. Databases with column-organized tables can be federated.
  B. Schemas that include column-organized tables can be transported.
  C. Sort memory can be automatically tuned in environments containing column-organized tables.
  D. Queries that use the Currently Committed semantics can be used with column-organized tables.
  A. Databases with column-organized tables can be federated.

• Question 26:

  What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?

  A. The number of times an attempt to queue a column-organized prefetch request for temporary table spaces was made but failed.
  B. The number of times a temporary error occurred while trying to queue a column-organized prefetch request for a regular table space.
  C. The number of times DB2 had to retrieve a page from disk for a temporary column-organized table because the page no longer resided in the buffer pool.
  D. The number of times an asynchronous read request failed when attempting to read temporary column- organized data from the buffer pool after the page had been flushed to disk.
  B. The number of times a temporary error occurred while trying to queue a column-organized prefetch request for a regular table space.

• Question 27:

  If the following commands are executed successfully:

  

  Which SQL statement will fail?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

• Question 28:

  When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width size for database tables?

  A. 32 KB
  B. 64 KB
  C. 1MB
  D. 2 MB
  B. 64 KB

• Question 29:

  In which type of database are column-organized tables supported?

  A. Partitioned databases.
  B. DB2 pureScale databases.
  C. Databases whose code set is Unicode.
  D. Databases whose code set is Non-Unicode.
  A. Partitioned databases.

• Question 30:

  Which scenario does NOT require intraquery parallelism?

  A. The execution of the LOAD command against an empty column-organized table.
  B. A DML operation that references a populated column-organized table.
  C. The execution of the RUNSTATS command against a populated column-organized table.
  D. The addition of a primary key constraint to an empty column-organized table.
  D. The addition of a primary key constraint to an empty column-organized table.