IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 41:

  A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The addition of COL4 will not support the uniqueness requirement of the index. In order to add this column to the index while still preserving the unique constraint of the first three columns, which option should be taken?

  A. Add a new index on COL4.
  B. Perform a ALTER INDEX IX1 ADD COLUMN (COL4).
  C. Add a new UNIQUE index on COL1, COL2, COL3, COL4.
  D. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).
  D. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).

• Question 42:

  In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?

  A. Turn on a monitor trace.
  B. Always have a performance trace running.
  C. Perform a DISPLAY DATABASE (LOCKS ) command often.
  D. Always have statistics classes 1,,3, and 4 and accounting classes 1 and 3 running.
  D. Always have statistics classes 1,,3, and 4 and accounting classes 1 and 3 running.

• Question 43:

  DB2 workfiles are critical to performance of applications. Which of the following will NOT assist with achieving best performance for workfile usage?

  A. Create several 4K and 32K workfiles.
  B. Assign workfiles to their own bufferpools.
  C. Assign workfiles to their own DASD volumes.
  D. Create one large workfile for the data sharing group.
  D. Create one large workfile for the data sharing group.

• Question 44:

  What kind of information is stored in SYSIBM.SYSCOPY?

  A. General information needed for recovery.
  B. Only information about existing image copies.
  C. Information about currently running and stopped copy jobs.
  D. Only information about objects which are currently in copy pending.
  A. General information needed for recovery.

• Question 45:

  The billing application has a DB2 referential integrity set of three tables. TABA, TABB and TABC. Daily, Full Image copies are done for the three table spaces related to the three tables. There is a requirement to recover the three table spaces to noon time, which is about 8 hours after the full image copies were run. Which one of the following statements is true about this recovery situation?

  A. Recovery will need to be done on the children table first.
  B. No recovery is allowed since the tables have been updated.
  C. No recovery is allowed, a QUIESCE utility is missing to create a point of consistency.
  D. BSDS contains information useful to find an appropriate RBA to use for the TORBA value.
  D. BSDS contains information useful to find an appropriate RBA to use for the TORBA value.

• Question 46:

  The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?

  A. Filter factor information.
  B. Stage 1 and stage 2 information.
  C. Number of columns used in an index.
  D. Number of times an SQL statement is executed.
  D. Number of times an SQL statement is executed.

• Question 47:

  Which minimum system privilege allows you to create a trusted context?

  A. DBADM
  B. SECADM
  C. SYSCTRL
  D. ACCESSCTRL
  B. SECADM

• Question 48:

  You take image copies of your table spaces every night. Since you cannot afford any data outage, you use the SHRLEVEL CHANGE option on your COPY utility control statement. Assume that write operations currently run on your table space while the image copies are being performed. Which of the following statements is true?

  A. Every FLASHCOPY generated with SHRLEVEL CHANGE will automatically be consistent.
  B. If you use the generated SHRLEVEL CHANGE option with RECOVER .. TOCOPY later on, DB2 determines the open URs and backs them out so that in the end your data will be consistent.
  C. You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies generated during the same utility execution will be inconsistent.
  D. You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies generated during the same utility execution will also be consistent.
  D. You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies generated during the same utility execution will also be consistent.

• Question 49:

  What is one of the first key steps in preparing to use the BACKUP SYSTEM utility?

  A. Run the MODIFY RECOVERY utility.
  B. Alter the BSDS to allow BACKUP SYSTEM.
  C. Define one or more storage groups to a COPYPOOL.
  D. Stop DB2 to enable DFSMShsm functionality to be used.
  C. Define one or more storage groups to a COPYPOOL.

• Question 50:

  Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?

  A. Issue ALTER TABLESPACE with a valid SEGSIZE > 0
  B. Make the table space table-partitioned, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
  C. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
  D. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, create a partitioned index and issue ALTER TABLESPACE with a valid SEGSIZE > 0
  B. Make the table space table-partitioned, then issue ALTER TABLESPACE with a valid SEGSIZE > 0