Proper study guides for Improve IBM DB2 10 DBA for z/OS certified begins with IBM C2090-612 preparation products which designed to deliver the Download C2090-612 questions by making you pass the C2090-612 test at your first time. Try the free C2090-612 demo right now.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-612 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-612 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-612-exam-dumps.html
Q61. What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?
A. KEEPDYNAMIC(YES) and CACHEDYN=YES
B. KEEPDYNAMIC(NO) and CACHEDYN=NO
C. KEEPDYNAMIC(NO) and REOPT(ALWAYS)
D. KEEPDYNAMIC(YES) and REOPT(ALWAYS)
Answer: A
Explanation:
Q62. Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?
A. Issue ALTER TABLESPACE with a valid SEGSIZE > 0
B. Make the table space table-partitioned, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
C. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
D. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, create a partitioned index and issue ALTER TABLESPACE with a valid SEGSIZE > 0
Answer: B
Explanation:
Q63. To monitor the storage used above and below the 2GB bar, what must occur?
A. Start a statistics class 1 trace.
B. Start a monitor class 1 & 2 trace.
C. Start an audit class 3 trace.
D. Start accounting class 7 & 8 traces.
Answer: A
Q64. 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?
A. Add a new index on COL4.
B. Perform a ALTER INDEX IX1 ADD COLUMN (COL4).
C. Add a new UNIQUE index on COL1, COL2, COL3, COL4.
D. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).
Answer: D
Explanation:
Q65. Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number 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 must be set to 1 for Java stored procedures.
B. NUMTCB parameter must be set to 1 for REXX stored procedures.
C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.
D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities.
Answer: B
Explanation:
Q66. In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?
A. Turn on a monitor trace.
B. Always have a performance trace running.
C. Perform a DISPLAY DATABASE (LOCKS ) command often.
D. Always have statistics classes 1.3, and 4 and accounting classes 1 and 3 running.
Answer: D
Topic 2, Volume B
Q67. The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class 3 Synchronous database I/O time. All of the DB2 objects for the new billing application are in BP5. What command can be used to research the details behind the database I/O time associated with the new billing application?
A. DISPLAY DDF DETAIL
B. START TRACE(AUDIT)
C. DISPLAY BUFFERPOOL(*)
D. DISPLAY BUFFERPOOL(BP5) LSTATS(ACTIVE) DETAIL
Answer: D
Explanation:
Q68. The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANGE with utilid REORGON. Which statement is NOT true?
A. It shows how many keys are rejected when issued during the SORTBLD phase.
B. It shows the elapsed time of the SWITCH phase when issued during the SWITCH phase.
C. It indicates how many parallel tasks are involved to build indexes when issued during the BUILD phase.
D. It shows an actual and estimated time of how far it has proceeded in the current iterations when issued during the LOG phase.
Answer: A
Explanation:
Q69. In which situation does adding a referential constraint place a table space containing data into check-pending status?
A. When a primary key is defined on a table with no unique index.
B. When a foreign key is defined on a table with the ENFORCED option.
C. When a foreign key is defined on a table and a corresponding primary key has not been defined.
D. When a foreign key is defined on a table with NOT ENFORCED option and a unique index has not been defined.
Answer: B
Explanation:
Q70. The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?
A. Issue a LOCK TABLE for all 4 tables.
B. Execute the SQL INSERT before the SQL UPDATE.
C. Provide an effective commit / restart process.
D. Run a QUIESCE utility before the process starts.
Answer: C
Explanation: