IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 101:

  When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?

  A. List prefetch
  B. Dynamic prefetch
  C. Sequential prefetch
  D. Skip sequential prefetch
  B. Dynamic prefetch

• Question 102:

  Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?

  A. 1
  B. 4
  C. 5
  D. 6
  D. 6

• Question 103:

  Which stored procedures need to be set up properly in order to register an XML schema?

  A. XSR_ADD_SCHEMA
  B. XSR_REGISTER and XSR_COMPLETE
  C. XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE
  D. The commands to register a XML schema do not invoke stored procedures.
  B. XSR_REGISTER and XSR_COMPLETE

• Question 104:

  When defining a foreign key on a table, which statement is true?

  A. It is not mandatory to have an index on the foreign key columns but it can help to avoid locking problems.
  B. There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key checking.
  C. It is not mandatory to have an index on the foreign key columns but it can help performance when you insert rows into this table.
  D. You must define an index on the foreign key columns where the index columns are the same as the foreign key columns to guarantee uniqueness of the foreign key.
  A. It is not mandatory to have an index on the foreign key columns but it can help to avoid locking problems.

• Question 105:

  What WLM action will establish performance objectives for DDF threads and their related address space?

  A. Insure the NUMTCB is set to a value greater than 10.
  B. Specify DDF for the value of APPLENV to the name of the WLM environment.
  C. Execute the WLM_REFRESH stored procedure for the DDF application environment.
  D. Create a WLM service definition that assigns service classes to the DDF threads.
  D. Create a WLM service definition that assigns service classes to the DDF threads.

• Question 106:

  What must be in place for the support of index compression?

  A. User defined algorithm.
  B. Compression dictionary.
  C. Table space compression.
  D. Page size larger than 4K.
  D. Page size larger than 4K.

• Question 107:

  Which connection type can exploit trusted connections?

  A. IMS
  B. CAF
  C. CICS
  D. RRSAF
  D. RRSAF

• Question 108:

  The threads initiated by the distributed transactions are no longer active in DB2, however this situation has caused -904 resource unavailable condition for the other executing threads in DB2. Which command could assist in identifying the remote locations from where such threads were triggered?

  A. -DISPLAY LOCATION(*) DETAIL
  B. -DIS THD(*) TYPE(INDOUBT) LOCATION(*) DETAIL
  C. -DIS THD(*) TYPE(INACTIVE) LOCATION(*) DETAIL
  D. -DIS THD(*) TYPE(POSTPONED) LOCATION(*) DETAIL
  B. -DIS THD(*) TYPE(INDOUBT) LOCATION(*) DETAIL

• Question 109:

  An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

  A. col2 is converted to EBCDIC
  B. col1 is converted to UNICODE
  C. SQLCode-270: Function not supported
  D. col2 and col1 are converted to UTF-32
  B. col1 is converted to UNICODE

• Question 110:

  Unnecessary REORGs of indexes may be avoided by which of the following?

  A. Use the SYSIBM.SYSINDEXSPACESTATS table.
  B. Use the REPORT utility to determine the degree of organization.
  C. Use the CHANGELIMIT keyword when creating an image copy of the index.
  D. Use the CHECK INDEX utility to find out if the index needs to be reorganized.
  A. Use the SYSIBM.SYSINDEXSPACESTATS table.