IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 51:

  In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)

  A. Column CLUSTERING in SYSIBM.SYSINDEXES
  B. Column LEAFDIST in SYSIBM.SYSINDEXPART
  C. Column CLUSTERRATIOF in SYSIBM.SYSINDEXES
  D. Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS
  E. Columns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART
  A. Column CLUSTERING in SYSIBM.SYSINDEXES
  D. Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS

• Question 52:

  The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANGE with utilid REORGON. Which statement is NOT true?

  A. It shows how many keys are rejected when issued during the SORTBLD phase.
  B. It shows the elapsed time of the SWITCH phase when issued during the SWITCH phase.
  C. It indicates how many parallel tasks are involved to build indexes when issued during the BUILD phase.
  D. It shows an actual and estimated time of how far it has proceeded in the current iterations when issued during the LOG phase.
  A. It shows how many keys are rejected when issued during the SORTBLD phase.

• Question 53:

  Which attribute(s) determine the absolute maximum number of partitions for a partition-by- growth table space?

  A. MAXPARTITIONS
  B. MAXPARTITIONS, DSSIZE
  C. MAXPARTITIONS, page size
  D. MAXPARTITIONS, DSSIZE, page size
  D. MAXPARTITIONS, DSSIZE, page size

• Question 54:

  Which authority level allows a user to run utilities that change the data in an application database?

  A. DBCTRL
  B. SYSOPR
  C. DBMAINT
  D. INSTALL SYSOPR
  A. DBCTRL

• Question 55:

  What DB2 command when issued displays what migration mode the catalog is in?

  A. DSNC DISPLAY
  B. DISPLAY GROUP
  C. MODIFY irlmproc,STATUS
  D. DISPLAY DATABASE (DSNDB06)
  B. DISPLAY GROUP

• Question 56:

  The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could have caused a table space scan to be chosen instead of the index?

  A. Index is created with PCTFREE of zero.
  B. The number of columns in the index is less than four.
  C. RUNSTATS were run when there were no rows in the table.
  D. RUNSTATS were run when there was a million rows in the table.
  C. RUNSTATS were run when there were no rows in the table.

• Question 57:

  Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who are not assistants?

  A. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);
  B. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/phone' as sql varchar(20);
  C. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);
  D. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/phone' as sql varchar(20);
  D. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/phone' as sql varchar(20);

• Question 58:

  Using the -SET LOG command, what logging characteristics CANNOT be modified?

  A. The number of minutes between the start of successive checkpoints.
  B. Add a newly defined active log data set to the active log inventory.
  C. Altering DB2 from dual active logging mode to single active logging mode.
  D. The number of log records that DB2 writes between the start of successive checkpoints.
  C. Altering DB2 from dual active logging mode to single active logging mode.

• Question 59:

  Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?

  A. The DB2 audit trace.
  B. The DB2 statistics trace.
  C. The DB2 connection trace.
  D. The DB2 accounting trace.
  B. The DB2 statistics trace.

• Question 60:

  What START TRACE command provides detailed lock suspend and lock contention trace information?

  A. START TRACE(AUDIT)
  B. START TRACE(STATS) CLASS(1)
  C. START TRACE(PERFM) CLASS(30) IFCID(44,45)
  D. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)
  C. START TRACE(PERFM) CLASS(30) IFCID(44,45)