IBM C2090-544 Online Practice Questions and Exam Preparation

IBM C2090-544 Online Questions & Answers

• Question 31:

  Which command CANNOT be used to create the compression dictionary for a table?

  A. IMPORT
  B. INSPECT
  C. LOAD
  D. RUNSTATS
  D. RUNSTATS

• Question 32:

  Given the following table spaces, their associated page size, and number of pages:

  

  Which sets of buffer pools will ensure that all of the data in the table spaces will be fit into memory for optimal data access?

  A. IBMDEFAULTBP - 16K page size, 85000 pages
  B. IBMDEFAULTBP - 4K page size, 25000 pagesBP1 -16K page size, 20000 pages
  C. BP1 - page size 8K, 45000 pages
  D. BP1 - 4K page size, 30000 pagesBP2 - 8K page size, 20000 pagesBP3 - 16K page size, 15000 pages
  D. BP1 - 4K page size, 30000 pagesBP2 - 8K page size, 20000 pagesBP3 - 16K page size, 15000 pages

• Question 33:

  A primary and standby database are enabled for HADR and are in peer state. The HADR_SYNCMODE configuration parameter is set to SYNC. An application connects to the primary database, issues a COMMIT and receives a successful return code in response. How were the log buffers for this unit of work processed?

  A. The log buffers were written to the DB2 log files on the primary server, sent to the standby, and written to log files on the standby server. The return code was then sent to the application.
  B. The log buffers were written to the DB2 log files on the primary server and received in the log buffers on the standby database. The return code was then sent to the application.
  C. The log buffers were written to the DB2 log files on the standby server and held in memory on the primary server. The return code was then sent to the application.
  D. The log buffers were written to the DB2 log files on the primary server and sent to TCP/IP send buffer to be shipped to the standby server. The return code was then sent to the application.
  A. The log buffers were written to the DB2 log files on the primary server, sent to the standby, and written to log files on the standby server. The return code was then sent to the application.

• Question 34:

  A DBA wants to migrate a DB2 LUW 8.2.2 database to version 9.7 and plans to use currently committed (CC) semantics on an application-by-application basis. Which process will yield the desired results?

  A. Set the DB2_USE_CC_SEMANTICS registry variable to YES, then migrate the database.
  B. Migrate the database, then assign the value ON to the CURR_COMMIT configuration parameter.
  C. Set the DB2_USE_CC_SEMANTICS registry variable to APPLICATION, then migrate the database.
  D. Migrate the database, then assign the value AVAILABLE to the CURR_COMMIT configuration parameter.
  D. Migrate the database, then assign the value AVAILABLE to the CURR_COMMIT configuration parameter.

• Question 35:

  Which action can be performed by the ALTER TABLESPACE statement?

  A. Change an SMS table space to a DMS table space on any database partition.
  B. Change the size of a container in an SMS table space.
  C. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.
  D. Add a container to an SMS table space on a database partition that currently has no containers.
  D. Add a container to an SMS table space on a database partition that currently has no containers.

• Question 36:

  Given a database created as follows:

  

  If each table (T1 and T2) has 50,000 rows, which of the following commands will ensure that the temporary table created by the select statement will fit entirely in the buffer pool, assuming that there is a primary key/foreign key relationship between column C1 in table T1, and column C1 in table T2?

  A. CREATE BUFFERPOOL bp1 SIZE 20000 PAGESIZE 4k;ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;
  B. CREATE BUFFERPOOL bp1 size 10000 PAGESIZE 8k;
  C. CREATE BUFFERPOOL bp1 size 5000 PAGESIZE 16k;ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;
  D. CREATE BUFFERPOOL bp1 size 25000 PAGESIZE 32k;
  B. CREATE BUFFERPOOL bp1 size 10000 PAGESIZE 8k;

• Question 37:

  Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?

  A. DB2_LIMIT_AS_CONTAINER_BLOCKS
  B. DB2_SET_MAX_CONTAINER_SIZE
  C. DB2_ALLOCATION_SIZE
  D. DB2_TRUNCATE_AS_STORAGE
  B. DB2_SET_MAX_CONTAINER_SIZE

• Question 38:

  A database named DB1 has a database partition group named MULTIPG that has been defined across partitions 3, 4 and 5. The DBA issues the following series of commands/SQL statements:

  CONNECT TO db1;

  SET CURRENT DBPARTITIONNUM 4;

  ALTER DATABASE PARTITION GROUP multigp ADD DBPARTITIONNUM (6);

  Which partition will DB2 use as a model for table spaces on partition 6?

  A. catalog partition
  B. partition 3
  C. partition 4
  D. partition 5
  B. partition 3

• Question 39:

  Given the following output from the GET DATABASE CONFIGURATION command:

  

  Which of the following DB configurations listed below will enable circular logging?

  A. LOGRETAIN=CIRCULAR
  B. LOGSECOND=-1
  C. LOGARCHMETH1=OFF and LOGARCHMETH2=OFF
  D. LOGPRIMARY=LOGCIRCULAR and LOGRETAIN=OFF
  C. LOGARCHMETH1=OFF and LOGARCHMETH2=OFF

• Question 40:

  The table STORESALES was created with the following statement:

  

  Which is true when the following statement is executed? CREATE UNIQUE INDEX index_partIDcustID ON storesales (partID, custID)

  A. A unique partitioned index is created successfully.
  B. A unique non-partitioned index is created successfully.
  C. The index creation fails because it does not contain the column from the table partitioning key.
  D. A non-unique partitioned index is created successfully.
  B. A unique non-partitioned index is created successfully.