IBM IBM Certified Database Administrator C2090-612 Questions & Answers

• Question 121:

  What is a consideration when specifying DATA CAPTURE CHANGES?

  A. Can be specified for capturing changes to an XML object.

  B. To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified.

  C. REFRESH TABLE statement is not allowed with a table defined with DATA CAPTURE CHANGES.

  D. You cannot turn on DATA CAPTURE CHANGES if the table space is in advisory REORG- pending.

  Correct Answer: D

• Question 122:

  In using plan stability, what storage space requirement should be of carefully monitored?

  A. MINSTOR

  B. DSNDB07

  C. DSNDB01.SPT01

  D. DSN_STATEMNT_TABLE

  Correct Answer: C

• Question 123:

  What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?

  A. KEEPDYNAMIC(YES) and CACHEDYN=YES

  B. KEEPDYNAMIC(NO) and CACHEDYN=NO

  C. KEEPDYNAMIC(NO) and REOPT(ALWAYS)

  D. KEEPDYNAMIC(YES) and REOPT(ALWAYS)

  Correct Answer: A

• Question 124:

  What START TRACE command provides detailed lock suspend and lock contention trace information?

  A. START TRACE(AUDIT)

  B. START TRACE(STATS) CLASS(1)

  C. START TRACE(PERFM) CLASS(30) IFCID(44,45)

  D. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)

  Correct Answer: C

• Question 125:

  What trace class will show deadlock information?

  A. Audit class 3.

  B. Statistic class 3.

  C. Accounting class 1.

  D. Performance class 8.

  Correct Answer: B

• Question 126:

  Which DSNZPARM will define the number of RID Blocks in the RID Pool?

  A. NUMTCB

  B. MAXRBLK

  C. CONDBAT

  D. URLGWTH

  Correct Answer: B

• Question 127:

  When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?

  A. List prefetch

  B. Dynamic prefetch

  C. Sequential prefetch

  D. Skip sequential prefetch

  Correct Answer: B

• Question 128:

  In order to retain an access path across a rebind which of the following commands could be used?

  A. BIND PLAN

  B. REBIND PACKAGE(PK1) REOPT(ONCE)

  C. BIND PACKAGE (PK1) EXPLAIN(YES)

  D. REBIND PACKAGE (PK1) PLANMGMT(BASIC)

  Correct Answer: D

• Question 129:

  When is a merge scan join a well performing access path?

  A. When the number of qualifying rows of the inner and outer table are both large.

  B. When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.

  C. When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.

  D. When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.

  Correct Answer: A

• Question 130:

  Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?

  A. NUMTCB parameter must be set to 1 for Java stored procedures.

  B. NUMTCB parameter must be set to 1 for REXX stored procedures.

  C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.

  D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities.

  Correct Answer: B