IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 21:

  Which ALTER TABLE statement will generate a new table space version?

  A. ALTER TABLE ... ADD PARTITION ...
  B. ALTER TABLE ... ADD COLUMN COL2 ...
  C. ALTER TABLE ... DATA CAPTURE CHANGES ...
  D. Altering an already existing VARCHAR column on the table to shorten its maximum length.
  B. ALTER TABLE ... ADD COLUMN COL2 ...

• Question 22:

  Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?

  A. CHECK LOB
  B. CHECK INDEX
  C. DSN1COPY
  D. DSN1CHKR
  D. DSN1CHKR

• Question 23:

  Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?

  A. Copy the index.
  B. REBUILD the index.
  C. Compress the tablespace.
  D. ALTER the index to use a page size larger than 4K.
  D. ALTER the index to use a page size larger than 4K.

• Question 24:

  Altering the DSSIZE is allowed for what type of table space?

  A. XML table space.
  B. Universal table space.
  C. Segmented table space.
  D. DSSIZE cannot be altered.
  B. Universal table space.

• Question 25:

  Which of the following techniques CANNOT be used to implement DB2 based row level authorization in a read-only environment for a specific table?

  A. Using a view.
  B. Using a VALIDPROC.
  C. Using multi-level security.
  D. Using masks and permissions.
  B. Using a VALIDPROC.

• Question 26:

  What is the DSNZPARM that determines the maximum amount of temporary storage in the work file data base for a single user at any given time?

  A. MAXRBLK
  B. MAXDBAT
  C. MAXKEEPD
  D. MAXTEMPS
  D. MAXTEMPS

• Question 27:

  The I/O patterns for objects in database NEWBILL need to be reviewed in detail. All of the NEWBILL work runs under a single plan, NEWBILLPL. What START TRACE command should be used to gather the I/O information needed for the objects in database NEWBILL?

  A. START TRACE(AUDIT) PLAN(NEWBILLPL)
  B. START TRACE(IO) CLASS(ALL) PLAN(NEWBILLPL)
  C. START TRACE(PERFM) CLASS(3) PLAN(NEWBILLPL)
  D. START TRACE(ACCT) CLASS(1,2,3) PLAN(NEWBILLPL)
  C. START TRACE(PERFM) CLASS(3) PLAN(NEWBILLPL)

• Question 28:

  When planning for backup/recovery (including disaster recovery), which statement is correct?

  A. When you remote copy everything (PPRC, XRC) there is no need to take DB2 image copies anymore.
  B. As data is shared in a data sharing group, disaster recovery in a data sharing environment is identical to a non-data sharing environment.
  C. System level backups (BACKUP SYSTEM) can be used for both system wide restore on a remote site, as well as the recovery of individual objects locally.
  D. When you want to create a consistent backup point, you must use the -SET LOG SUSPEND command to freeze all activity, and then take your backups with whatever technology you prefer.
  C. System level backups (BACKUP SYSTEM) can be used for both system wide restore on a remote site, as well as the recovery of individual objects locally.

• Question 29:

  Which statement is true about table check constraints?

  A. Only one constraint per column is allowed.
  B. The LOAD utility cannot enforce the constraint.
  C. A constraint placed on a table does not apply to a view defined on the table.
  D. A row meets the requirement of the constraint if the condition evaluates to true or unknown.
  D. A row meets the requirement of the constraint if the condition evaluates to true or unknown.

• Question 30:

  A single table should allow for up to 100 Terabytes of application data. How do you design your table space?

  A. A segmented compressed table space, BUFFERPOOL BP0.
  B. A LOB table space with DSSIZE 64GB, BUFFERPOOL BP8K0.
  C. A table space with NUMPARTS 1024, DSSIZE 64G, BUFFERPOOL BP16K0.
  D. A table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K.
  D. A table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K.