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

When is a merge scan join a well performing access path?

  1. When the number of qualifying rows of the inner and outer table are both large.

  2. When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.

  3. When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.

  4. When the matching columns of the inner table are in a non-clustering index or the outer table has duplicatequalifying rows.

Answer: A

Question No: 2 – (Topic 1)

Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and thenumber of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?

  1. NUMTCB parameter must be set to 1 for Java stored procedures.

  2. NUMTCB parameter must beset to 1 for REXX stored procedures.

  3. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.

  4. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities.

Answer: B

Question No: 3 – (Topic 1)

What is the purpose of the following query? SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME, TP.TSNAMEFROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAME AND TP.TSNAME = TS.NAME);

  1. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.

  2. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.

  3. It identifies whichtable spaces have missing related rows in SYSIBM.SYSTABLEPART.

  4. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.

Answer: C

Question No: 4 – (Topic 1)

In using plan stability, what storage space requirement should be of carefully monitored?

  1. MINSTOR

  2. DSNDB07

  3. DSNDB01.SPT01

  4. DSN_STATEMNT_TABLE

Answer: C

Question No: 5 – (Topic 1)

How can you find out which externaland native stored procedures are active in the system?

  1. Use the -DIS PROCEDURE(*.*) command.

  2. Use the -DIS THREAD(*) TYPE(PROC) command.

  3. There is no WLM or DB2 command to obtain this information.

  4. You can only obtain this information indirectly if you know the WLM application environment by issuing the D WLM,APPLENV=xxxx command.

Answer: C

Question No: 6 – (Topic 1)

In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)

  1. Column CLUSTERING in SYSIBM.SYSINDEXES

  2. Column LEAFDIST in SYSIBM.SYSINDEXPART

  3. Column CLUSTERRATIOF in SYSIBM.SYSINDEXES

  4. Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS

  5. Columns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART

Answer: A,D

Question No: 7 – (Topic 1)

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

  1. LOB table space.

  2. Segmented table space.

  3. Range-partitioned tablespace.

  4. Partition-by-growth table space.

Answer: D

Question No: 8 – (Topic 1)

Which authoritylevel allows a user to run utilities that change the data in an application database?

  1. DBCTRL

  2. SYSOPR

  3. DBMAINT

  4. INSTALL SYSOPR

Answer: A

Question No: 9 – (Topic 1)

What would be a reason for altering the clustering index of a table?

  1. To increase free space.

  2. Because the clusteringindex has to match the primary index.

  3. To choose a clustering index to favor batch sequential processing.

  4. To choose a clustering index to promote sequential inserts at the end of the table space.

Answer: C

Question No: 10 – (Topic 1)

Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?

  1. Does not apply tothreads that were defined with RELEASE(COMMIT).

  2. Does not apply to threads that were defined with RELEASE(DEALLOCATE).

  3. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next COMMIT point.

  4. Applies to RELEASE(COMMIT) at the next COMMIT point and to RELEASE(DEALLOCATE) at thread end.

Answer: C

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