IBM IBM Certified Advanced Database Administrator C2090-611 Questions & Answers

• Question 1:

  What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the Job Manager in IBM Data Studio?

  A. Permission to log in to the database client using telnet.

  B. Permission to log in to the database server using telnet.

  C. Permission to log in to the database client using secure shell (SSH).

  D. Permission to log in to the database server using secure shell (SSH).

  Correct Answer: D

• Question 2:

  How can you obtain information about any changes that have been made by the Self-Tuning Memory Manager (STMM)?

  A. By using the change history event monitor.

  B. By using the DB2 problem determination tool.

  C. By examining the contents of the system catalog.

  D. By examining the DB2 administration notification log file.

  Correct Answer: A

• Question 3:

  Which statement about DB2 aggregate registry variables is true?

  A. An aggregate registry variable that is explicitly set by an application cannot be overwritten.

  B. An aggregate registry variable overrides any corresponding explicitly set registry variable.

  C. A registry variable that is explicitly set by an application can only be overwritten by aggregate registry variable.

  D. A registry variable that is implicitly configured through an aggregate registry variable may also be explicitly defined.

  Correct Answer: D

• Question 4:

  A table named CUSTOMER and an index named CUST_IDX were created as follows:

  

  Which operation would you expect to see in the access plan diagram produced?

  A. NLJOIN

  B. HSJOIN

  C. IXSCAN

  D. TBSCAN

  Correct Answer: C

• Question 5:

  Which command will enable automatic reorg on a database?

  A. UPDATE DB CFG USING AUTO_REORG ON

  B. UPDATE DB CFG USING AUTO_MAINT ON AUTO_REORG ON

  C. UPDATE DB CFG USING AUTO_TBL_MAINT ON AUTO_REORG ON

  D. UPDATE DB CFG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_REORG ON

  Correct Answer: D

• Question 6:

  Which statement about triggers is FALSE?

  A. A statement-level trigger fires only once for each SQL statement.

  B. A trigger's code block can be executed either before or after a triggering event.

  C. A row-level trigger fires once for each row that is affected by a triggering event.

  D. A table-level trigger fires once for each table that is affected by a triggering event.

  Correct Answer: D

• Question 7:

  Which registry variable should be used to specify that 20 percent of each index page is to be left as as free space when building any index in any database?

  A. DB2_INDEX_DEFAULT

  B. DB2_EXTENDED_OPTIMIZATION

  C. DB2_INDEX_PCTFREE_DEFAULT

  D. DB2_ENABLE_AUTOCONFIG_DEFAULT

  Correct Answer: C

• Question 8:

  What are two types of check options that can be used to create views? (Choose two.)

  A. Local

  B. Client

  C. Server

  D. Remote

  E. Cascaded

  Correct Answer: AE

• Question 9:

  Which statement about referential constraints is true?

  A. A referential constraint can be defined against a catalog table.

  B. A referential constraint can be defined on both tables and views.

  C. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.

  D. A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query.

  Correct Answer: C

• Question 10:

  Which statement about primary keys is true?

  A. A table can have multiple primary keys.

  B. A primary key accepts one, and only one, NULL value.

  C. A unique index, with matching columns of the primary key, must be created before a primary key can be created.

  D. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.

  Correct Answer: D