IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 111:

  Which of the following does NOT make a view a read-only view?

  A. The outer fullselect contains a GROUP BY clause.
  B. The first SELECT clause specifies the keyword DISTINCT.
  C. The only table referenced is a system maintained temporal table and a period-specification is specified.
  D. Any FROM clause, after the first, identifies more than one table or view, or identifies a table function, a nested table expression, or a common table expression.
  D. Any FROM clause, after the first, identifies more than one table or view, or identifies a table function, a nested table expression, or a common table expression.

• Question 112:

  What is the result of the command -RECOVER POSTPONED CANCEL if the postponed-abort thread that you cancel was in the middle of a series of updates when DB2 abended?

  A. The underlying page sets are stopped.
  B. The underlying page sets are placed in REFP restrictive state.
  C. The underlying page sets are placed in REORP restrictive state.
  D. No restrictive state is set. It is your responsibility to ensure data consistency.
  B. The underlying page sets are placed in REFP restrictive state.

• Question 113:

  Your current backup strategy is to run COPY SHRLEVEL CHANGE for all your table spaces each night. You create FULL image copies once a week and INCREMENTAL copies during the rest of the days. After migrating to DB2 10, you plan to create the FULL image copies using FLASHCOPY YES and COPYDDN, that is you create a flash copy image copy (FCIC) and additionally a sequential copy. What happens to the incremental copies that you continue to create on all other days?

  A. If DSNZPARM FLASHCOPY_COPY is set to YES, the incremental copies will automatically be incremental FLASHCOPY copies.
  B. Nothing special. The only difference is that the FULL copy, which is the basis for the subsequent incremental copies has now been generated from the FCIC.
  C. The COPY utilities with FULL NO option will not run. If there are entries in SYSIBM.SYSCOPY that indicate that FCICs exist for a give page set, INCREMENTAL copies cannot be taken anymore.
  D. The first image copy utility execution after the FULL FCIC and sequential copy created from the FCIC will end up as FULL copy although you specify the FULL NO statement on the COPY utility control statement.
  D. The first image copy utility execution after the FULL FCIC and sequential copy created from the FCIC will end up as FULL copy although you specify the FULL NO statement on the COPY utility control statement.

• Question 114:

  In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used?

  A. GBP32
  B. SCA
  C. LOCK
  D. GBP0
  B. SCA

• Question 115:

  Which DB2 online utility job output provides you with information about the BACKUP SYSTEM history?

  A. DSNJU003
  B. DSNJU004
  C. DIAGNOSE
  D. REPORT with RECOVERY option
  D. REPORT with RECOVERY option

• Question 116:

  Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)

  A. LOG NO
  B. SORTKEYS 16
  C. FASTSWITCH YES
  D. AUTOESTSPACE YES
  E. DRAIN_WAIT and RETRY
  C. FASTSWITCH YES
  E. DRAIN_WAIT and RETRY

• Question 117:

  The UNLOAD utility can be used to do which of the following functions?

  A. Unload compressed data.
  B. Unload rows from a FlashCopy image copy.
  C. Unload data from an image copy of an index.
  D. Unload rows from an image copy that has rows from a dropped table.
  A. Unload compressed data.

• Question 118:

  A table space is in AREO*. What does this status mean?

  A. A full image copy of the table space must be taken.
  B. The table space should be reorganized for optimal performance.
  C. A START command must be issued to remove it from the pending status.
  D. The table space must be reorganized to materialize all pending changes.
  B. The table space should be reorganized for optimal performance.

• Question 119:

  Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?

  A. The dynamic statement cache is enabled.
  B. The client application contains some explainable statements.
  C. The PLAN_TABLE and DSN_STATEMENT_CACHE tables must be created using a EBCDIC encoding scheme.
  D. Both PLAN_TABLE and DSN_STATEMENT_CACHE_TABLE exist on the DB2 server and the table names are qualified with the current SQLID that is used when running the application.
  C. The PLAN_TABLE and DSN_STATEMENT_CACHE tables must be created using a EBCDIC encoding scheme.

• Question 120:

  An object (table space, index space or a physical partition of a table space or index space) is in AREST or RESTP status. If backout activity is not already underway, what should occur?

  A. Issue a RECOVER POSTPONED command.
  B. Issue a START command with ACCESS(RW).
  C. Recycle the system with the system parameter LBACKOUT=NO.
  D. Issue a STOP command and then a START command with ACCESS(RW).
  A. Issue a RECOVER POSTPONED command.