IBM C2090-612 - DB2 10 DBA for z/OS Exam

Page:    1 / 27   
Total 133 questions

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 duplicatequalifying rows.


Answer : A

Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and thenumber 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 beset 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.


Answer : B

What is the purpose of the following query? SELECT DBNAME, NAME FROM
SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME,
TP.TSNAMEFROM 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 whichtable 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.


Answer : C

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

  • A. MINSTOR
  • B. DSNDB07
  • C. DSNDB01.SPT01
  • D. DSN_STATEMNT_TABLE


Answer : C

How can you find out which externaland 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.


Answer : C

Page:    1 / 27   
Total 133 questions