Ensurepass.com : Ensure you pass the IT Exams
2017 Nov 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: 31 – (Topic 1)

The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?

  1. Filter factor information.

  2. Stage 1 and stage 2 information.

  3. Number of columns used in an index.

  4. Number of times anSQL statement is executed.

Answer: D

Question No: 32 – (Topic 1)

When converting a multiple table segmented table space to partition-by-growth table spaces, which statement is correct?

  1. DSMAX may have to be increased.

  2. Storage requirements for EDMDBDC will decrease.

  3. Storage requirements for some applications will increase.

  4. The dynamic statement cache should be increased to handle the additional SQL statements.

Answer: A

Question No: 33 – (Topic 1)

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

  1. MAXRBLK

  2. MAXDBAT

  3. MAXKEEPD

  4. MAXTEMPS

Answer: D

Question No: 34 – (Topic 1)

You have to design a table and application layout, in which automatic number generationis used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which statement is true?

  1. Neither Identity nor Sequence can deliver this functionality.

  2. Identity can deliver this functionality, but Sequence cannot.

  3. Identity cannot deliver this functionality, but Sequence can.

  4. Identity and Sequence can both deliver this functionality.

Answer: C

Question No: 35 – (Topic 1)

What is a consideration when specifying DATA CAPTURE CHANGES?

  1. Can be specified for capturing changes to an XML object.

  2. To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified.

  3. REFRESH TABLE statement is not allowed with a table defined with DATA CAPTURE CHANGES.

  4. You cannot turn on DATA CAPTURE CHANGES if the table space is in advisoryREORG-pending.

Answer: D

Question No: 36 – (Topic 1)

A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The addition of COL4 will not support the uniqueness requirement of the index. In order to add this column to the index while still preserving the unique constraint of the first three columns, which option should be taken?

  1. Add a new index on COL4.

  2. Perform a ALTER INDEX IX1 ADD COLUMN (COL4).

  3. Add a new UNIQUE index on COL1, COL2, COL3, COL4.

  4. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).

Answer: D

Question No: 37 – (Topic 1)

Thefollowing DDL statements are executed to create the following objects: CREATE TABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1 INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEX USER1.IX1 ON USER1.TB1 ( COL2 ) BUFFERPOOL BP0 COPY YES;Next, the following ALTER

statements are done (in order): 1) ALTER TABLESPACE DB1.TS1 BUFFERPOOL BP8K0 MAXPARTITIONS 20; 2) ALTER TABLESPACE DB1.TS1 SEGSIZE 64; 3) ALTER INDEX

USER1.IX1 BUFFERPOOL BP16K0; Which of the following will materialize all of thechanges with the least amount of work?

  1. Nothing needs to be done.

  2. REORG INDEX USER1.IX1 SHRLEVEL CHANGE

  3. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE

  4. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE REORG INDEX USER1.IX1 SHRLEVEL CHANGE

Answer: C

Question No: 38 – (Topic 1)

The billing application has a DB2 referential integrity setof three tables. TABA, TABB and TABC. Daily, Full Image copies are done for the three table spaces related to the three tables. There is a requirement to recover the three table spaces to noon time, which is about 8 hours after the full image copies were run. Which one of the following statements is true about this recovery situation?

  1. Recovery will need to be done on the children table first.

  2. No recovery is allowed since the tables have been updated.

  3. No recovery is allowed, a QUIESCE utility is missing to create a point of consistency.

  4. BSDS contains information useful to find an appropriate RBA to use for the TORBA value.

Answer: D

Question No: 39 – (Topic 1)

Which statement is NOT true?

  1. REORG table space to materialize pending definition changes for a table space.

  2. REORG with SHRLEVEL CHANGE would automatically detect which threads need to be canceled before switch phase.

  3. DSNACCOX can be used for collecting data for table space and index space for getting recommendations when to run REORG, RUNSTATS or

    COPY.

  4. REORG of index space could be eliminated because the list prefetch of index leaf pages in DB2 V10 is based on non-leaf page information.

Answer: B

Question No: 40 – (Topic 1)

A table space is in AREO*. What does this status mean?

  1. A full image copy of the tablespace must be taken.

  2. The table space should be reorganized for optimal performance.

  3. A START command must be issued to remove it from the pending status.

  4. The table space must be reorganized to materialize all pending changes.

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-612 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass 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

2017 EnsurePass IT Certification PDF and VCE