IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 1:

  Which option allows the UNLOAD utility to unload LOBs into output files together with non-LOB data?

  A. DELIMITED
  B. SPANNED YES
  C. DSNTYPE HFS on the TEMPLATE
  D. DSNTYPE LIBRARY or PDS on the TEMPLATE
  B. SPANNED YES

• Question 2:

  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)
  D. REBIND PACKAGE (PK1) PLANMGMT(BASIC)

• Question 3:

  You have to design a table and application layout, in which automatic number generation is used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which statement is true?

  A. Neither Identity nor Sequence can deliver this functionality.
  B. Identity can deliver this functionality, but Sequence cannot.
  C. Identity cannot deliver this functionality, but Sequence can.
  D. Identity and Sequence can both deliver this functionality.
  C. Identity cannot deliver this functionality, but Sequence can.

• Question 4:

  If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?

  A. Nothing because DB2 will control the values.
  B. A unique index must be defined on the ROWID column.
  C. An identity column must also be created to control uniqueness.
  D. Extra space must be allocated for an overflow area in the table space.
  B. A unique index must be defined on the ROWID column.

• Question 5:

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

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

• Question 6:

  To monitor the storage used above and below the 2GB bar, what must occur?

  A. Start a statistics class 1 trace.
  B. Start a monitor class 1 and 2 trace.
  C. Start an audit class 3 trace.
  D. Start accounting class 7 and 8 traces.
  A. Start a statistics class 1 trace.

• Question 7:

  Which of the following types of SQL statements are NOT eligible to be stored in the dynamic SQL statement cache?

  A. MERGE
  B. INSERT
  C. SELECT
  D. OPEN
  D. OPEN

• Question 8:

  What is a potential consideration when using triggers?

  A. They are not invoked by the LOAD REPLACE utility.
  B. When using views, the underlying tables cannot have a trigger defined.
  C. RI and check constraints are evaluated prior to any trigger invocation.
  D. They run in a WLM managed address space, so invoking them frequently (e.g. when using a row level trigger) can be costly.
  A. They are not invoked by the LOAD REPLACE utility.

• Question 9:

  Which DB2 performance feature is designed specifically to reduce the number of indexes that need to be created?

  A. Inline LOBs.
  B. Include columns.
  C. Hash row access.
  D. Direct row access.
  B. Include columns.

• Question 10:

  When is changing an index from non-clustering to clustering NOT allowed?

  A. If the table space is defined as member cluster.
  B. If the data is not ordered by the new clustering index.
  C. If the new clustering index is for a table that uses hash organization.
  D. If the new clustering index OBID is greater than the old clustering index OBID.
  C. If the new clustering index is for a table that uses hash organization.