IBM IBM Certifications C2090-600 Questions & Answers

• Question 31:

  What levels of authority are needed to create a storage group? (Choose two.)

  A. DBADM

  B. SYSADM

  C. SQLADM

  D. SYSCTRL

  E. SYSMAINT

  Correct Answer: BD

• Question 32:

  A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (inserts, updates, and deletes).

  Sunday – Delta

  Monday – Incremental

  Tuesday – Delta

  Wednesday – Delta

  Thursday – Incremental

  Friday – Delta

  Saturday – Full

  Which day would you expect a RECOVER DATABASE following that day's backup to take the longest time to complete?

  A. Friday

  B. Monday

  C. Saturday

  D. Wednesday

  Correct Answer: A

• Question 33:

  Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

  A. Creating, using, or altering thresholds

  B. Granting, altering, or revoking workload privileges

  C. Using or altering the default service classes and workloads

  D. Creating service classes, service subclasses, and workloads

  E. Creating, activating, stopping or dropping workload management event monitors

  Correct Answer: BD

• Question 34:

  When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?

  A. UPDATE DB CFG USING MON_OBJ_METRICS BASE

  B. UPDATE DB CFG USING MON_ACT_METRICS BASE

  C. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON

  D. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON

  Correct Answer: C

• Question 35:

  What is the result of the following scenario?

  

  A. The row is updated to (2, NULL)

  B. The row is updated to (2, 110.00)

  C. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed

  D. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL

  Correct Answer: B

• Question 36:

  Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

  A. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC

  B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES

  C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90

  D. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

  Correct Answer: C

• Question 37:

  A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?

  A. All data, both new and existing, will becompressed.

  B. Only new or updated data for XML columns will be compressed.

  C. New and existing XML columns will be compressed but other columns remain unchanged.

  D. Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.

  Correct Answer: D

• Question 38:

  Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

  A. It does not apply to table space backups.

  B. It specifies the compression mode to use for DB2 backups.

  C. It only has effect when appliedto a database in which all tables have been compressed.

  D. If set, backup images created with the BACKUP command are automatically compressed.

  Correct Answer: D

• Question 39:

  Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

  A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

  B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

  C. CONNECT TO sample;UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;

  D. ATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

  Correct Answer: C

• Question 40:

  A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.

  Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

  A. REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;

  B. REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;

  C. RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;

  D. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

  Correct Answer: A