IBM DB2 10 DBA for z/OS - C2090-612 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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

A. Create several 4K and 32K workfiles. B. Create one large workfile for the data sharing group. C. Assign workfiles to their own bufferpools. D. Assign workfiles to their own DASD volumes.

Discussion 0

Correct Answer: B Vote an answer

Question 2

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

A. SYSIBM.SYSTABLEPART_HIST
CARDF, SPACEF
SYSIBM.SYSINDEXPART_HIST
CARDF, SPACEF B. SYSIBM.SYSTABLESPACESTATS
SPACE
SYSIBM.SYSINDEXSPACESTATS
SPACE C. SYSIBM.SYSTABLEPART
CARDF, SPACEF
SYSIBM.SYSINDEXPART
CARDF, SPACEF D. SYSIBM.SYSTABLESPACE
DSSIZE, AVGROWLEN
SYSIBM.SYSINDEXES
PIECESIZE, AVGKEYLEN

Discussion 0

Correct Answer: D Vote an answer

Question 3

If security administration isseparated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?

A. INSTALL SYSOPR B. SECADM C. SYSADM D. DBADM

Discussion 0

Correct Answer: B Vote an answer

Question 4

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?

A. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures. B. NUMTCB parameter must be set to 1 for Java stored procedures. C. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities. D. NUMTCB parameter must beset to 1 for REXX stored procedures.

Discussion 0

Correct Answer: D Vote an answer

Question 5

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

A. Partition-by-growth table space. B. Range-partitioned tablespace. C. LOB table space. D. Segmented table space.

Discussion 0

Correct Answer: A Vote an answer

Question 6

An object (table space, index space or a physical partition of a table space or index space) is in AREST or RESTP status. If backout activity is not already underway, what should occur?

A. Issue a RECOVER POSTPONED command. B. Issue a START command with ACCESS(RW). C. Issue a STOPcommand and then a START command with ACCESS(RW). D. Recycle the system with the system parameter LBACKOUT=NO.

Discussion 0

Correct Answer: A Vote an answer

Question 7

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

A. A START command must be issued to remove it from the pending status. B. The table space must be reorganized to materialize all pending changes. C. A full image copy of the tablespace must be taken. D. The table space should be reorganized for optimal performance.

Discussion 0

Correct Answer: D Vote an answer

Question 8

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

A. If the new clustering index is for a table that uses hash organization. B. If the new clustering index OBID is greater than the old clustering index OBID. C. If the table space isdefined as member cluster. D. If the data is not ordered by the new clustering index.

Discussion 0

Correct Answer: A Vote an answer

Question 9

Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?

A. The client application contains some explainable statements. B. Both PLAN_TABLE and DSN_STATEMENT_CACHE_TABLE exist on the DB2 server and the table names are qualified with the current SQLID that is used when running the application. C. The PLAN_TABLE and DSN_STATEMENT_CACHE tables must be created using a EBCDIC encoding scheme. D. The dynamic statement cache is enabled.

Discussion 0

Correct Answer: C Vote an answer