IBM IBM Certified Database Administrator C2090-612 Questions & Answers

• Question 81:

  You take image copies of your table spaces every night. Since you cannot afford any data outage, you use the SHRLEVEL CHANGE option on your COPY utility control statement. Assume that write operations currently run on your table space while the image copies are being performed. Which of the following statements is true?

  A. Every FLASHCOPY generated with SHRLEVEL CHANGE will automatically be consistent.

  B. If you use the generated SHRLEVEL CHANGE option with RECOVER .. TOCOPY later on, DB2 determines the open URs and backs them out so that in the end your data will be consistent.

  C. You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies generated during the same utility execution will be inconsistent.

  D. You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies generated during the same utility execution will also be consistent.

  Correct Answer: D

• Question 82:

  During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?

  A. RBA

  B. LRSN

  C. ROWID

  D. SYSPITRT

  Correct Answer: B

• Question 83:

  When planning for backup/recovery (including disaster recovery), which statement is correct?

  A. When you remote copy everything (PPRC, XRC) there is no need to take DB2 image copies anymore.

  B. As data is shared in a data sharing group, disaster recovery in a data sharing environment is identical to a non-data sharing environment.

  C. System level backups (BACKUP SYSTEM) can be used for both system wide restore on a remote site, as well as the recovery of individual objects locally.

  D. When you want to create a consistent backup point, you must use the -SET LOG SUSPEND command to freeze all activity, and then take your backups with whatever technology you prefer.

  Correct Answer: C

• Question 84:

  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

  Correct Answer: D

• Question 85:

  Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pending state AND creates an entry in SYSIBM.SYSCOPY?

  A. Run the BACKUP SYSTEM utility.

  B. Run the REPAIR SET NOCOPYPEND utility.

  C. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.

  D. Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 - 10.

  Correct Answer: C

• Question 86:

  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 87:

  You have to design a numeric column, which is also the primary key. The column should cover large (i.e., 123456789012345678) numbers. Which column data definition covers the requirements?

  A. BIGINT

  B. INTEGER

  C. DECFLOAT (34)

  D. DECIMAL (31,18)

  Correct Answer: A

• Question 88:

  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

  Correct Answer: B

• Question 89:

  Which statement is true about table check constraints?

  A. Only one constraint per column is allowed.

  B. The LOAD utility cannot enforce the constraint.

  C. A constraint placed on a table does not apply to a view defined on the table.

  D. A row meets the requirement of the constraint if the condition evaluates to true or unknown.

  Correct Answer: D

• Question 90:

  Given the following view definition: CREATE VIEW EMPD AS (SELECT D.DEPTNAME,

  A. LASTNAME FROM DEPT D INNER JOIN EMP E ON D.DEPTNO = E.WORKDEPT); Can an UPDATE statement be used to update the view EMPD on joined tables DEPT and EMP?

  B. No, an UPDATE statement against the EMPD view is not allowed at all.

  C. Yes, the view EMPD can be updated directly via an UPDATE statement.

  D. No, only a clone of the view EMPD can be updated via an UPDATE statement.

  E. Yes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is defined on the view.

  Correct Answer: D