IBM IBM Certified Database Administrator C2090-612 Questions & Answers

• Question 31:

  A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?

  A. The data is only stored in the auxiliary table.

  B. The data is only stored in the base table.

  C. The complete data is stored both in auxiliary and in base table.

  D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.

  Correct Answer: B

• Question 32:

  When modeling data to provide for a physical design, which of the following defines the data types for the columns in the DB2 physical table?

  A. Domain

  B. Entities

  C. Attributes

  D. Primary Key

  Correct Answer: C

• Question 33:

  A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?

  A. Specify the column names to be hashed.

  B. Create a unique index on the hash columns.

  C. Create a clustering index on the hash columns.

  D. Create a unique clustering index on the hash columns.

  Correct Answer: A

• Question 34:

  Which of the following does NOT make a view a read-only view?

  A. The outer fullselect contains a GROUP BY clause.

  B. The first SELECT clause specifies the keyword DISTINCT.

  C. The only table referenced is a system maintained temporal table and a period-specification is specified.

  D. Any FROM clause, after the first, identifies more than one table or view, or identifies a table function, a nested table expression, or a common table expression.

  Correct Answer: D

• Question 35:

  Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?

  A. Copy the index.

  B. REBUILD the index.

  C. Compress the tablespace.

  D. ALTER the index to use a page size larger than 4K.

  Correct Answer: D

• Question 36:

  You want to ALTER a table space specifying MAXPARTITIONS 256. For which table space type does the ALTER fail?

  A. Simple table space with one table.

  B. Segmented table space with one table.

  C. Classic partitioned table space with one table.

  D. Partitioned-by-growth table space with one table.

  Correct Answer: C

• Question 37:

  Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?

  A. 1

  B. 4

  C. 5

  D. 6

  Correct Answer: D

• Question 38:

  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.

  Correct Answer: A

• Question 39:

  Which clone table statement is correct?

  A. A clone table can have its own indexes.

  B. A clone table has its own catalog statistics.

  C. The clone and base tables share a table space.

  D. The clone and base tables must have different schema names.

  Correct Answer: C

• Question 40:

  In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used?

  A. GBP32

  B. SCA

  C. LOCK

  D. GBP0

  Correct Answer: B