Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-612
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-612.html

DB2 10 DBA for z/OS

Question No: 71 – (Topic 2)

What WLM action will establish performance objectives for DDF threadsand their related address space?

  1. Insure the NUMTCB is set to a value greater than 10.

  2. Specify DDF for the value of APPLENV to the name of the WLM environment.

  3. Execute the WLM_REFRESH stored procedure for the DDF application environment.

  4. Createa WLM service definition that assigns service classes to the DDF threads.

Answer: D

Question No: 72 – (Topic 2)

When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of the different page sizes?

  1. DIAGNOSE

  2. DSN1COMP

  3. DSN1PRNT

  4. DSN1LOGP

Answer: B

Question No: 73 – (Topic 2)

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?

  1. CREATE INDEX empname1 ON dept(info)

    GENERATE KEY USING XMLPATTERN #39;//name#39; as sql varchar(20); CREATE INDEX empphone1 ON dept(info)

    GENERATE KEY USINGXMLPATTERN #39;//phone#39; as sql varchar(20);

  2. CREATE INDEX empname1 ON dept(info)

    GENERATE KEY USING XMLPATTERN #39;//name#39; as sql varchar(20); CREATE INDEX empphone1 ON dept(info)

    GENERATE KEY USING XMLPATTERN #39;/deptinfo/phone#39; as sql varchar(20);

  3. CREATE INDEX empname1 ON dept(info)

    GENERATE KEY USING XMLPATTERN #39;/deptinfo/name#39; as sql varchar(20); CREATE INDEX empphone1 ON dept(info)

    GENERATE KEY USING XMLPATTERN #39;//phone#39; as sql varchar(20);

  4. CREATE INDEX empname1 ON dept(info)

GENERATE KEY USINGXMLPATTERN #39;/deptinfo/employee/name#39; as sql varchar(20); CREATE INDEX empphone1 ON dept(info)

GENERATE KEY USING XMLPATTERN #39;/deptinfo/employee/phone#39; as sql varchar(20);

Answer: D

Question No: 74 – (Topic 2)

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

  1. Create several 4K and 32K workfiles.

  2. Assign workfiles to their own bufferpools.

  3. Assign workfiles to their own DASD volumes.

  4. Create one large workfile for the data sharing group.

Answer: D

Question No: 75 – (Topic 2)

When is changing an index from non-clustering to clustering NOT allowed?

  1. If the table space isdefined as member cluster.

  2. If the data is not ordered by the new clustering index.

  3. If the new clustering index is for a table that uses hash organization.

  4. If the new clustering index OBID is greater than the old clustering index OBID.

Answer: C

Question No: 76 – (Topic 2)

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

  1. The DB2 subsystem wasat some point in in NFM.

  2. The DB2 subsystem can still fall back to DB2 Version 8.

  3. Coexistence is allowed with a DB2 9 data sharing group member.

  4. The asterisk (*) indicates objects created in NFM can no longer be accessed.

Answer: A

Question No: 77 – (Topic 2)

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?

  1. Domain

  2. Entities

  3. Attributes

  4. Primary Key

Answer: C

Question No: 78 – (Topic 2)

Which of the following statements is NOT correct?

  1. UNLOAD with NOPAD improves performance.

  2. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).

  3. Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.

  4. Clone table allows replacing data without renames and rebinds to support online load replace.

Answer: B

Question No: 79 – (Topic 2)

Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?

  1. 1

  2. 4

  3. 5

  4. 6

Answer: D

Question No: 80 – (Topic 2)

Whenspecifying quot;Aquot; for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?

  1. An inbound ID is subject to translation.

  2. A request does not need an authentication token.

  3. With this option, VTAM cannot be defined with SECACPT=ALREADYV.

  4. For outbound requests, the encrypted password is extracted from RACF.

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-612 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-612 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.