IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 91:

  What IBM provided stored procedure will access DB2 real time statistics tables?

  A. DSNAEXP
  B. DSNAIMS
  C. DSNACCOX
  D. DSNLEUSR
  C. DSNACCOX

• Question 92:

  On what type of index would an ALTER INDEX ADD COLUMN be allowed?

  A. An XML index.
  B. An auxiliary index.
  C. A user defined catalog index.
  D. An index defined with BUSINESS_TIME WITHOUT OVERLAPS.
  C. A user defined catalog index.

• Question 93:

  Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

  A. SECADM authority.
  B. ACCESSCTRL authority.
  C. DATAACCESS authority.
  D. SYSADM authority when SEPARATE_SECURITY=NO.
  E. The owner of the object as he/she has that authority implicitly.
  A. SECADM authority.
  D. SYSADM authority when SEPARATE_SECURITY=NO.

• Question 94:

  If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?

  A. The next sort step will perform two sorts.
  B. There are multiple sorts in the plan step.
  C. One sort in the plan step will accomplish two tasks.
  D. Two sorts are performed on the new table of a star join.
  C. One sort in the plan step will accomplish two tasks.

• Question 95:

  Which of the following types of table spaces allow multiple tables?

  A. Segmented
  B. LOB table space
  C. Partition-by-range
  D. Partition-by-growth
  A. Segmented

• Question 96:

  For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?

  A. Catalog tables
  B. Directory tables
  C. Auxiliary tables
  D. Declared global temporary tables
  A. Catalog tables

• Question 97:

  For monitoring space growth over time, which statistics should NOT be considered?

  A. SYSIBM.SYSTABLEPART_HIST CARDF, SPACEF SYSIBM.SYSINDEXPART_HIST CARDF, SPACEF
  B. SYSIBM.SYSTABLEPART CARDF, SPACEF SYSIBM.SYSINDEXPART CARDF, SPACEF
  C. SYSIBM.SYSTABLESPACE DSSIZE, AVGROWLEN SYSIBM.SYSINDEXES PIECESIZE, AVGKEYLEN
  D. SYSIBM.SYSTABLESPACESTATS SPACE SYSIBM.SYSINDEXSPACESTATS SPACE
  C. SYSIBM.SYSTABLESPACE DSSIZE, AVGROWLEN SYSIBM.SYSINDEXES PIECESIZE, AVGKEYLEN

• Question 98:

  Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.)

  A. Append
  B. Inline LOBs
  C. Member cluster
  D. Volatile table
  E. Include columns
  A. Append
  C. Member cluster

• Question 99:

  What is the purpose of the following query? SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME, TP.TSNAME FROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAME AND TP.TSNAME = TS.NAME);

  A. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.
  B. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.
  C. It identifies which table spaces have missing related rows in SYSIBM.SYSTABLEPART.
  D. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.
  C. It identifies which table spaces have missing related rows in SYSIBM.SYSTABLEPART.

• Question 100:

  Which trace gives information about frequent log space shortages?

  A. Audit trace class(8)
  B. Statistics trace class(3)
  C. Accounting trace class(10)
  D. Performance trace class(4)
  B. Statistics trace class(3)