2017 Nov IBM Official New Released C2090-612
100% Free Download! 100% Pass Guaranteed!

DB2 10 DBA for z/OS

Question No: 81 – (Topic 2)

Which DSNZPARM parameter controls thenumber of locks that may be acquired on a table space?





Answer: C

Question No: 82 – (Topic 2)

The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could have caused a table space scan to be chosen instead of theindex?

  1. Index is created with PCTFREE of zero.

  2. The number of columns in the index is less than four.

  3. RUNSTATS were run when there were no rows in the table.

  4. RUNSTATS were run when there was a million rows in the table.

Answer: C

Question No: 83 – (Topic 2)

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

  1. Run the MODIFY RECOVERY utility.

  2. Alter the BSDS to allow BACKUP SYSTEM.

  3. Define one or more storage groups to a COPYPOOL.

  4. Stop DB2 to enable DFSMShsm functionality to be used.

Answer: C

Question No: 84 – (Topic 2)

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?

  1. Increase DWQT to 10.

  2. Decrease VPSIZE by 45,000 pages.

  3. Increase VPSIZE to 180,000 pages.

  4. Change the buffer pool to use PGFIX(YES).

Answer: C

Question No: 85 – (Topic 2)

To monitor the storage used above and below the 2GB bar, what must occur?

  1. Start a statistics class 1 trace.

  2. Start a monitor class 1 amp; 2 trace.

  3. Start an audit class 3 trace.

  4. Start accounting class 7 amp; 8 traces.

Answer: A

Question No: 86 – (Topic 2)

Which of the following does NOT make a view a read-only view?

  1. The outer fullselect contains a GROUP BY clause.

  2. The first SELECT clause specifies the keyword DISTINCT.

  3. The only table referenced is asystem maintained temporal table and a period- specification is specified.

  4. Any FROM clause, after the first, identifies more than one table or view, or identifies a table function, a nested table expression, or a common

table expression.

Answer: D

Question No: 87 – (Topic 2)

You want to ALTER a table space specifying MAXPARTITIONS 256. For which table space type does the ALTER fail?

  1. Simple table space with one table.

  2. Segmented table space withone table.

  3. Classic partitioned table space with one table.

  4. Partitioned-by-growth table space with one table.

Answer: C

Question No: 88 – (Topic 2)

In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used?

  1. GBP32

  2. SCA

  3. LOCK

  4. GBP0

Answer: B

Question No: 89 – (Topic 2)

Unnecessary REORGs of indexes may be avoided by which of the following?


  2. Use the REPORT utility to determine the degree of organization.

  3. Use the CHANGELIMIT keyword when creating an image copy ofthe index.

  4. Use the CHECK INDEX utility to find out if the index needs to be reorganized.

Answer: A

Question No: 90 – (Topic 2)

When these two commands are issued in sequence, one after the other: STOP FUNCTION SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B) ACTION(QUEUE)

What will occur?

  1. Function A.B is stopped and queues all access.

  2. Function A.B is stopped and rejects all access.

  3. Function A.B is stopped and rejects all access until we start the function or run out of installation timeout.

  4. Function A.B is stopped and queues all access until we start the function or run out of installation timeout.

Answer: D

100% Free Download!
Download Free Demo:C2090-612 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-612 Full Exam PDF and VCE

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

2017 EnsurePass IT Certification PDF and VCE