IBM C2090-611 Online Practice Questions and Exam Preparation

IBM C2090-611 Online Questions & Answers

• Question 101:

  You want to modify an existing view so that any rows that are inserted or updated with the view will not violate the SELECT statement that was used to create the view. What should you do?

  A. Alter the view and add the ENFORCE SELECT clause to the view definition.
  B. Drop and recreate the view with the WITH CHECK OPTION clause specified.
  C. Alter the view and add the WITH CHECK OPTION clause to the view definition.
  D. Create a new view with the same name and the ENFORCE SELECT clause specified.
  B. Drop and recreate the view with the WITH CHECK OPTION clause specified.

• Question 102:

  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 103:

  Given the following statement:

  

  How many constraints are present in the DEPARTMENT table?

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

• Question 104:

  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 105:

  Which statement describes a way to minimize the impact of a RUNSTATS operation?

  A. Reduce I/O by using a shadow table space for statistics collection.
  B. Execute the RUNSTATS command with the WITH DISTRIBUTION option specified.
  C. Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified.
  D. Limit the number of pages and rows processed by using page-level or row-level table sampling.
  D. Limit the number of pages and rows processed by using page-level or row-level table sampling.

• Question 106:

  Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?

  A. db2pd
  B. db2dart
  C. db2look
  D. db2mimic
  C. db2look

• Question 107:

  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 108:

  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 109:

  Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?

  A. db2set ALT_DIAGPATH=/db2data/db2dump2
  B. db2set SECONDARY_DIAGPATH=/db2data/db2dump2
  C. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2
  D. UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2
  C. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2

• Question 110:

  What authorization is needed to execute the CREATE MASK statement?

  A. SECADM
  B. SQLADM
  C. SYSADM
  D. SYSCTRL
  A. SECADM