IBM IBM Certified Database Administrator C2090-612 Questions & Answers

• Question 71:

  Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?

  A. Does not apply to threads that were defined with RELEASE(COMMIT).

  B. Does not apply to threads that were defined with RELEASE(DEALLOCATE).

  C. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next COMMIT point.

  D. Applies to RELEASE(COMMIT) at the next COMMIT point and to RELEASE(DEALLOCATE) at thread end.

  Correct Answer: C

• Question 72:

  The billing application has a DB2 referential integrity set of three tables. TABA, TABB and TABC. Daily, Full Image copies are done for the three table spaces related to the three tables. There is a requirement to recover the three table spaces to noon time, which is about 8 hours after the full image copies were run. Which one of the following statements is true about this recovery situation?

  A. Recovery will need to be done on the children table first.

  B. No recovery is allowed since the tables have been updated.

  C. No recovery is allowed, a QUIESCE utility is missing to create a point of consistency.

  D. BSDS contains information useful to find an appropriate RBA to use for the TORBA value.

  Correct Answer: D

• Question 73:

  Which statement is NOT true?

  A. REORG table space to materialize pending definition changes for a table space.

  B. REORG with SHRLEVEL CHANGE would automatically detect which threads need to be canceled before switch phase.

  C. DSNACCOX can be used for collecting data for table space and index space for getting recommendations when to run REORG, RUNSTATS or COPY.

  D. REORG of index space could be eliminated because the list prefetch of index leaf pages in DB2 V10 is based on non-leaf page information.

  Correct Answer: B

• Question 74:

  For monitoring space growth over time, which statistics should NOT be considered?

  A. SYSIBM.SYSTABLEPART_HIST CARDF, SPACEF SYSIBM.SYSINDEXPART_HIST CARDF, SPACEF

  B. SYSIBM.SYSTABLEPART CARDF, SPACEF SYSIBM.SYSINDEXPART CARDF, SPACEF

  C. SYSIBM.SYSTABLESPACE DSSIZE, AVGROWLEN SYSIBM.SYSINDEXES PIECESIZE, AVGKEYLEN

  D. SYSIBM.SYSTABLESPACESTATS SPACE SYSIBM.SYSINDEXSPACESTATS

  SPACE

  Correct Answer: C

• Question 75:

  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.

  Correct Answer: B

• Question 76:

  Which of the following results in improving performance of a load job to load data into an indexed partitioned table space with multiple indexes?

  A. LOG YES

  B. PREFORMAT

  C. SORTKEYS integer

  D. convert input data

  Correct Answer: C

• Question 77:

  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.

  Correct Answer: A

• Question 78:

  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.

  Correct Answer: B

• Question 79:

  DB2 does not take system checkpoints in which circumstance?

  A. During an application rollback.

  B. At the end of a successful restart.

  C. When switching from one active log data set to another.

  D. When a specified number of log records are created or after a specified number of minutes, whichever occurs first.

  Correct Answer: A

• Question 80:

  How can you find out which external and native stored procedures are active in the system?

  A. Use the -DIS PROCEDURE(*.*) command.

  B. Use the -DIS THREAD(*) TYPE(PROC) command.

  C. There is no WLM or DB2 command to obtain this information.

  D. You can only obtain this information indirectly if you know the WLM application environment by issuing the D WLM,APPLENV=xxxx command.

  Correct Answer: C