IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 71:

  The performance of BP5 is being evaluated. The Page residency time is being used to see if VPSIZE should be changed. The statistics that are available are VPSIZE of 90,000 and VPSEQT of 15 %. There are 4458 synch I/O per second and 1696 async I/O per second. 6154 total pages read. The system page residency time is 14.6 seconds. Based on a system page residency time of 14.6 seconds, what should be done to increase page residency time?

  A. Increase DWQT to 10.
  B. Decrease VPSIZE by 45,000 pages.
  C. Increase VPSIZE to 180,000 pages.
  D. Change the buffer pool to use PGFIX(YES).
  C. Increase VPSIZE to 180,000 pages.

• Question 72:

  Which of the following tasks cannot be done via a single ALTER TABLE statement?

  A. Add a new partition to the table space.
  B. Change the VALIDPROC attribute of the table.
  C. Change a table check constraint on the table.
  D. Change the DATA CAPTURE attribute of the table.
  C. Change a table check constraint on the table.

• Question 73:

  In a normalized design, in third normal form, the entity defined in the logical design is often transformed in the physical design to which of the following?

  A. Index
  B. Table
  C. Schema
  D. Database
  B. Table

• Question 74:

  If SEGSIZE 64 and MAXPARTITIONS 10 are specified in a CREATE TABLESPACE statement, what type of table space is created?

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

• Question 75:

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

  DB2 10 is in enabling-new-function mode* after migrating from Version 8, which statement is correct?

  A. The DB2 subsystem was at some point in in NFM.
  B. The DB2 subsystem can still fall back to DB2 Version 8.
  C. Coexistence is allowed with a DB2 9 data sharing group member.
  D. The asterisk (*) indicates objects created in NFM can no longer be accessed.
  A. The DB2 subsystem was at some point in in NFM.

• Question 77:

  When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the SECURITY clause specify?

  A. DB2
  B. RACF
  C. USER
  D. DEFINER
  C. USER

• Question 78:

  In the CFRM policy, what is the purpose of the PREFLIST?

  A. To identify the size of the structure.
  B. To identify all the DB2 members in the group.
  C. To identify the preferences for DB2 restart in the event of a disconnection.
  D. To identify the preferences for structure rebuild/reallocation during a coupling facility failure.
  D. To identify the preferences for structure rebuild/reallocation during a coupling facility failure.

• Question 79:

  When specifying "A" for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?

  A. An inbound ID is subject to translation.
  B. A request does not need an authentication token.
  C. With this option, VTAM cannot be defined with SECACPT=ALREADYV.
  D. For outbound requests, the encrypted password is extracted from RACF.
  B. A request does not need an authentication token.

• Question 80:

  Which DSNZPARM will define the number of RID Blocks in the RID Pool?

  A. NUMTCB
  B. MAXRBLK
  C. CONDBAT
  D. URLGWTH
  B. MAXRBLK