IBM IBM Certified Database Administrator C2090-612 Questions & Answers

• Question 11:

  Using the -SET LOG command, what logging characteristics CANNOT be modified?

  A. The number of minutes between the start of successive checkpoints.

  B. Add a newly defined active log data set to the active log inventory.

  C. Altering DB2 from dual active logging mode to single active logging mode.

  D. The number of log records that DB2 writes between the start of successive checkpoints.

  Correct Answer: C

• Question 12:

  Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?

  A. CHECK LOB

  B. CHECK INDEX

  C. DSN1COPY

  D. DSN1CHKR

  Correct Answer: D

• Question 13:

  The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANGE with utilid REORGON. Which statement is NOT true?

  A. It shows how many keys are rejected when issued during the SORTBLD phase.

  B. It shows the elapsed time of the SWITCH phase when issued during the SWITCH phase.

  C. It indicates how many parallel tasks are involved to build indexes when issued during the BUILD phase.

  D. It shows an actual and estimated time of how far it has proceeded in the current iterations when issued during the LOG phase.

  Correct Answer: A

• Question 14:

  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.

  Correct Answer: A

• Question 15:

  DB2 workfiles are critical to performance of applications. Which of the following will NOT assist with achieving best performance for workfile usage?

  A. Create several 4K and 32K workfiles.

  B. Assign workfiles to their own bufferpools.

  C. Assign workfiles to their own DASD volumes.

  D. Create one large workfile for the data sharing group.

  Correct Answer: D

• Question 16:

  What is the appropriate action to maintain data consistency if your page set is in REFP restrictive state?

  A. Recover the table space to current.

  B. Run the REORG utility with SHRLEVEL NONE.

  C. Run a Point In Time RECOVER or the LOAD REPLACE utility.

  D. Issue command -START DB(yourdb) SP(yourtbspace) ACCESS(FORCE).

  Correct Answer: C

• Question 17:

  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.

  Correct Answer: D

• Question 18:

  What is the purpose of the following query? SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME, TP.TSNAME FROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAME AND TP.TSNAME = TS.NAME);

  A. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.

  B. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.

  C. It identifies which table spaces have missing related rows in SYSIBM.SYSTABLEPART.

  D. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.

  Correct Answer: C

• Question 19:

  When these two commands are issued in sequence, one after the other: STOP FUNCTION SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B) ACTION(QUEUE) What will occur?

  A. Function A.B is stopped and queues all access.

  B. Function A.B is stopped and rejects all access.

  C. Function A.B is stopped and rejects all access until we start the function or run out of installation timeout.

  D. Function A.B is stopped and queues all access until we start the function or run out of installation timeout.

  Correct Answer: D

• Question 20:

  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

  Correct Answer: B