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: 41 – (Topic 1)

If a single row of the PLAN_TABLE has a #39;Y#39; value in more than one of the sort composite columns, what is indicated?

  1. The next sort step will perform two sorts.

  2. There are multiple sorts in the plan step.

  3. One sort in the plan step will accomplish twotasks.

  4. Two sorts are performed on the new table of a star join.

Answer: C

Question No: 42 – (Topic 1)

What START TRACE command provides detailed lock suspend and lock contention trace information?

  1. START TRACE(AUDIT)

  2. START TRACE(STATS) CLASS(1)

  3. START TRACE(PERFM) CLASS(30) IFCID(44,45)

  4. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)

Answer: C

Question No: 43 – (Topic 1)

For which table type could you specify ALTERTABLE tb1 DATA CAPTURE CHANGES?

  1. Catalog tables

  2. Directory tables

  3. Auxiliary tables

  4. Declared global temporary tables

Answer: A

Question No: 44 – (Topic 1)

Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH

DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?

  1. ALTER TABLE TB1 AUDIT CHANGES;

  2. ALTER TABLE TB1 ADD COLUMN COLC DATE;

  3. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;

  4. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS SECURITY LABEL;

Answer: B

Question No: 45 – (Topic 1)

For monitoring space growth over time, which statistics should NOT be considered?

  1. SYSIBM.SYSTABLEPART_HIST CARDF, SPACEF SYSIBM.SYSINDEXPART_HIST CARDF, SPACEF

  2. SYSIBM.SYSTABLEPART CARDF, SPACEF SYSIBM.SYSINDEXPART CARDF, SPACEF

  3. SYSIBM.SYSTABLESPACE DSSIZE, AVGROWLEN SYSIBM.SYSINDEXES PIECESIZE, AVGKEYLEN

  4. SYSIBM.SYSTABLESPACESTATS SPACE SYSIBM.SYSINDEXSPACESTATS SPACE

Answer: C

Question No: 46 – (Topic 1)

When defining a foreign key on a table, which statement is true?

  1. It is not mandatory to have anindex on the foreign key columns but it can help to avoid locking problems.

  2. There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key checking.

  3. It is not mandatory to have an index on the foreign key columns but it can help

    performance when you insert rows into this table.

  4. You must define an index on the foreign key columns where the index columns are the same as the foreign key columns to guarantee

uniqueness of the foreign key.

Answer: A Explanation:

If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?

  1. Nothing because DB2 will control the values.

  2. A unique index must be defined on the ROWID column.

  3. An identity column must also be created to control uniqueness.

  4. Extra space must be allocated for an overflow area in the table space. Answer: B

Question No: 47 – (Topic 1)

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?

  1. DB2

  2. RACF

  3. USER

  4. DEFINER

Answer: C

Question No: 48 – (Topic 1)

The available window to reorganize table spaces is being reduced. What data can provide information to allow for a priority list of candidate table spaces for reorganization based on recentactivity with no recent RUNSTATS execution?

  1. SYSIBM.SYSCOPY

  2. SYSIBM.SYSTABLES

  3. SYSIBM.SYSINDEXES

  4. SYSIBM.SYSTABLESPACESTATS

Answer: D

Question No: 49 – (Topic 1)

Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?

  1. TheDB2 audit trace.

  2. The DB2 statistics trace.

  3. The DB2 connection trace.

  4. The DB2 accounting trace.

Answer: B

Question No: 50 – (Topic 1)

The threads initiated by the distributed transactions are no longer active in DB2, however this situation has caused -904 resourceunavailable condition for the other executing threads in DB2. Which command could assist in identifying the remote locations from where such threads were triggered?

  1. -DISPLAY LOCATION(*) DETAIL

  2. -DIS THD(*) TYPE(INDOUBT) LOCATION(*) DETAIL

  3. -DIS THD(*) TYPE(INACTIVE) LOCATION(*) DETAIL

  4. -DIS THD(*) TYPE(POSTPONED) LOCATION(*) DETAIL

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-612 Demo PDF
100% Ensurepass Free 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
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE