IBM C2090-611 Online Practice Questions and Exam Preparation

IBM C2090-611 Online Questions & Answers

• Question 41:

  What is the FLUSH PACKAGE CACHE statement used for?

  A. It saves dynamic SQL stored in the package cache to an external file.
  B. To remove all cached static SQL statements from the package cache.
  C. To remove all cached dynamic SQL statements from the package cache.
  D. It causes all SQL statements in the package cache that are currently in use to be recompiled.
  C. To remove all cached dynamic SQL statements from the package cache.

• Question 42:

  Table TAB_A resides within table space TBSP_1.

  

  Which statement is correct?

  A. TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular columns and hidden columns. Whilenew data is being loaded into TAB_A, applications will be able to read the data that existed prior to the LOAD operation.
  B. A flash copy of TAB_A will be made at the beginning of the LOAD because of the COPY YES option. This copy allows applications to read thedata that existed in the table prior to the LOAD operation and improves performance since the read operations will not collide with the LOAD.
  C. The indexes for TAB_A will not be completely rebuilt because the INCREMENTAL indexing mode is used. Instead, new index keys will beappended to the original indexes. This will improve concurrency for the applications that are reading TAB_A during the LOAD operation.
  D. The indexes for TAB_A will be copied at the beginning of the LOAD operation because of the COPY YES option. Since the indexes will also bebuilt using the INCREMENTAL indexing mode, the concurrency of table TAB_A will be maximized for any applications that wish to access thetable.
  A. TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular columns and hidden columns. Whilenew data is being loaded into TAB_A, applications will be able to read the data that existed prior to the LOAD operation.

• Question 43:

  Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command can be used to recover the database and repair the corruption in table space TBSP_1?

  A. RESTART DATABASE
  B. RECOVER DATABASE
  C. RESTORE TABLESPACE
  D. ROLLFORWARD DATABASE
  B. RECOVER DATABASE

• Question 44:

  What information can be obtained by analyzing EXPLAIN data?

  A. Access type, index use, and work load
  B. Index use, work load, and join methods
  C. Work load, access type, and join methods
  D. Join methods, index use, and access type
  D. Join methods, index use, and access type

• Question 45:

  Table TAB1 was created as follows:

  

  Which statement(s) should be used to create an index on column COL1 of table TAB1 that is enabled for compression?

  A. CREATE INDEX tab1_idx ON tab1(col1);
  B. CREATE INDEX tab1_idx ON tab1(col1);ALTER INDEX tab1_idx COMPRESS YES;
  C. CREATE INDEX tab1_idx ON tab1(col1);REORG INDEX tab1_idx FOR TABLE tab1;
  D. CREATE INDEX tab1_idx ON tab1(col1);ALTER INDEX tab1_idx COMPRESS YES;REORG INDEX tab1_idx FOR TABLE tab1;
  A. CREATE INDEX tab1_idx ON tab1(col1);

• Question 46:

  If the following statement is executed:

  

  What indexes will be created for table TAB1?

  A. 1 dimension-block index and 1 composite-block index
  B. 1 dimension-block index and 3 composite-block indexes
  C. 3 dimension-block indexes and 1 composite-block index
  D. 3 dimension-block indexes and 3 composite-block indexes
  C. 3 dimension-block indexes and 1 composite-block index

• Question 47:

  A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?

  A. Set the DISCOVER_DB database manager configuration parameter for the DEV instance to DISABLE.
  B. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the client to DISABLE.
  C. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the server to DISABLE.
  D. Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.
  D. Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.

• Question 48:

  Which statement about DB2 aggregate registry variables is true?

  A. An aggregate registry variable that is explicitly set by an application cannot be overwritten.
  B. An aggregate registry variable overrides any corresponding explicitly set registry variable.
  C. A registry variable that is explicitly set by an application can only be overwritten by aggregate registry variable.
  D. A registry variable that is implicitly configured through an aggregate registry variable may also be explicitly defined.
  D. A registry variable that is implicitly configured through an aggregate registry variable may also be explicitly defined.

• Question 49:

  Which statement is true regarding client-server database connectivity?

  A. A remote connection uses Interprocess Communication (IPC).
  B. A loopback connection can be made with either the APPC or TCP/IP protocol enabled.
  C. A remote connection is established between a DB2 client in a different location from the database server.
  D. A DB2 client running a lower version of DB2 can establish a local connection to a server running on a newer version.
  C. A remote connection is established between a DB2 client in a different location from the database server.

• Question 50:

  Which statement describes adaptive row compression?

  A. Adaptive compression allows for use of customized compression dictionary creation algorithms.
  B. Adaptive compression maintains a dynamic and ever changing table-level row compression dictionary.
  C. Adaptive compression incorporates both classic table-level row compression and page-by-page based row compression.
  D. Adaptive compression incorporates four compression approaches: tablespace-level, table-level, page- level, and bufferpool-level.
  C. Adaptive compression incorporates both classic table-level row compression and page-by-page based row compression.