IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 121:

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

  Which statement about encoding schemes is correct?

  A. A view can have columns with different encoding schemes.
  B. A table can have columns with different encoding schemes.
  C. A table space can have tables with different encoding schemes.
  D. All objects in the subsystem must use the same encoding schemes.
  A. A view can have columns with different encoding schemes.

• Question 123:

  Which of the following results in improving performance of a load job to load data into an indexed partitioned table space with multiple indexes?

  A. LOG YES
  B. PREFORMAT
  C. SORTKEYS integer
  D. convert input data
  C. SORTKEYS integer

• Question 124:

  When modeling data to provide for a physical design, which of the following defines the data types for the columns in the DB2 physical table?

  A. Domain
  B. Entities
  C. Attributes
  D. Primary Key
  C. Attributes

• Question 125:

  How do you enable parallelism in a dynamic SQL statement?

  A. BIND with DEGREE(1)
  B. BIND with DEGREE(ANY)
  C. Use SET CURRENT DEGREE = ANY
  D. Use SET CURRENT DEGREE = '1'
  C. Use SET CURRENT DEGREE = ANY

• Question 126:

  Given the following statements have been run successfully and the buffer pools BP1 and BP2 both have the same page size: CREATE TABLESPACE TS1 IN DB1 DEFINE YES BUFFERPOOL BP1 MAXPARTITIONS 15 MEMBER CLUSTER ; CREATE TABLE TB1 (COL1 INT NOT NULL WITH DEFAULT) IN DB1.TS1 ; COMMIT ; ALTER TABLESPACE TS1 BUFFERPOOL BP2 MAXPARTITIONS 20 ; What is the next logical step in the sequence to CREATE an index IX1 on COL1 on TB1?

  A. ALTER TABLESPACE TS1 MAXPARTITIONS 15;
  B. COMMIT;
  C. CREATE INDEX IX1 ON TB1 (COL1);
  D. REORG TABLESPACE TS1;
  C. CREATE INDEX IX1 ON TB1 (COL1);

• Question 127:

  In using plan stability, what storage space requirement should be of carefully monitored?

  A. MINSTOR
  B. DSNDB07
  C. DSNDB01.SPT01
  D. DSN_STATEMNT_TABLE
  C. DSNDB01.SPT01

• Question 128:

  During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?

  A. RBA
  B. LRSN
  C. ROWID
  D. SYSPITRT
  B. LRSN

• Question 129:

  The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired. To provide additional information on update patterns for the new Billing Application, the DBA can use what information to better understand the unpredictable workload patterns on the tablespaces?

  A. SYSIBM.SYSCOPY
  B. SYSIBM.SYSSTATS
  C. SYSIBM.SYSTABLES
  D. SYSIBM.SYSTABLESPACESTATS
  D. SYSIBM.SYSTABLESPACESTATS

• Question 130:

  If security administration is separated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?

  A. SYSADM
  B. DBADM
  C. SECADM
  D. INSTALL SYSOPR
  C. SECADM