IBM C2090-611 Online Practice Questions and Exam Preparation

IBM C2090-611 Online 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).
  D. Permission to log in to the database server using secure shell (SSH).

• Question 2:

  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.
  D. A registry variable that is implicitly configured through an aggregate registry variable may also be explicitly defined.

• Question 3:

  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.
  A. By using the change history event monitor.

• Question 4:

  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
  D. UPDATE DB CFG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_REORG ON

• Question 5:

  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
  C. IXSCAN

• Question 6:

  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
  C. DB2_INDEX_PCTFREE_DEFAULT

• Question 7:

  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.
  D. A table-level trigger fires once for each table that is affected by a triggering event.

• Question 8:

  Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?

  A. SET INTEGRITY FOR mytab IMMEDIATE CHECKED
  B. ALTER TABLE mytab CHECK (COL IS VALIDATED)
  C. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED
  D. ALTER TABLE mytab ALLOW READ ACCESS;SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;
  A. SET INTEGRITY FOR mytab IMMEDIATE CHECKED

• Question 9:

  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.
  D. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.

• Question 10:

  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.
  C. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.