IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 31:

  How can you find out which external and 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.
  C. There is no WLM or DB2 command to obtain this information.

• Question 32:

  What is the maximum levels of backup that DB2 plan stability can support?

  A. 1
  B. 2
  C. 3
  D. 4
  C. 3

• Question 33:

  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.
  C. It identifies which table spaces have missing related rows in SYSIBM.SYSTABLEPART.

• Question 34:

  Which of the following statements is NOT correct?

  A. UNLOAD with NOPAD improves performance.
  B. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).
  C. Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.
  D. Clone table allows replacing data without renames and rebinds to support online load replace.
  B. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).

• Question 35:

  The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?

  A. The encoding scheme of the table is EBCDIC.
  B. The encoding scheme of the table is UNICODE.
  C. This could never happen, this is an error and must be reported.
  D. This is expected behavior and independent of the encoding scheme.
  B. The encoding scheme of the table is UNICODE.

• Question 36:

  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.
  D. You cannot turn on DATA CAPTURE CHANGES if the table space is in advisory REORG- pending.

• Question 37:

  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)
  A. KEEPDYNAMIC(YES) and CACHEDYN=YES

• Question 38:

  When planning for disaster recovery, which two items are NOT required to send to the remote site? (Choose two.)

  A. DB2 archive logs.
  B. Image copies of indexes.
  C. A copy of your ICF catalog.
  D. Image copies of table spaces.
  E. Backups of the DB2 catalog and directory.
  B. Image copies of indexes.
  C. A copy of your ICF catalog.

• Question 39:

  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)
  A. BIGINT

• Question 40:

  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.
  B. NUMTCB parameter must be set to 1 for REXX stored procedures.