Act now and download your IBM C2090-612 test today! Do not waste time for the worthless IBM C2090-612 tutorials. Download Update IBM DB2 10 DBA for z/OS exam with real questions and answers and begin to learn IBM C2090-612 with a classic professional.


♥♥ 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

Q31. What is one of the first key steps in preparing to use the BACKUP SYSTEM utility? 

A. Run the MODIFY RECOVERY utility. 

B. Alter the BSDS to allow BACKUP SYSTEM. 

C. Define one or more storage groups to a COPYPOOL. 

D. Stop DB2 to enable DFSMShsm functionality to be used. 

Answer: C 

Explanation: 


Q32. Which stored procedures need to be set up properly in order to register an XML schema? 

A. XSR_ADD_SCHEMA 

B. XSR_REGISTER and XSR_COMPLETE 

C. XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE 

D. The commands to register a XML schema do not invoke stored procedures. 

Answer: B 

Explanation: 


Q33. Which of the following techniques CANNOT be used to implement DB2 based row level authorization in a read-only environment for a specific table? 

A. Using a view. 

B. Using a VALIDPROC. 

C. Using multi-level security. 

D. Using masks and permissions. 

Answer: B 

Explanation: 


Q34. The performance of BP5 is being evaluated. The Page residency time is being used to see if VPSIZE should be changed. The statistics that are available are VPSIZE of 90,000 and VPSEQT of 15 %. There are 4458 synch I/O per second and 1696 async I/O per second. 6154 total pages read. The system page residency time is 14.6 seconds. Based on a system page residency time of 

14.6 seconds, what should be done to increase page residency time? 

A. Increase DWQT to 10. 

B. Decrease VPSIZE by 45,000 pages. 

C. Increase VPSIZE to 180,000 pages. 

D. Change the buffer pool to use PGFIX(YES). 

Answer: C 

Explanation: 


Q35. Which statement about encoding schemes is correct? 

A. A view can have columns with different encoding schemes. 

B. A table can have columns with different encoding schemes. 

C. A table space can have tables with different encoding schemes. 

D. All objects in the subsystem must use the same encoding schemes. 

Answer: A 

Explanation: 


Q36. During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members? 

A. RBA 

B. LRSN 

C. ROWID 

D. SYSPITRT 

Answer: B 

Explanation: 


Q37. Which privilege allows the execution of the EXPLAIN STMTCACHE ALL SQL statement? 

A. SYSOPR 

B. SYSCTRL 

C. SQLADM 

D. SECADM 

Answer: C 

Explanation: 


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

A. The DB2 audit trace. 

B. The DB2 statistics trace. 

C. The DB2 connection trace. 

D. The DB2 accounting trace. 

Answer: B 

Explanation: 


Q39. What DB2 command when issued displays what migration mode the catalog is in? 

A. DSNC DISPLAY 

B. DISPLAY GROUP 

C. MODIFY irlmproc,STATUS 

D. DISPLAY DATABASE (DSNDB06) 

Answer: B 

Explanation: 


Q40. When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often? 

A. List prefetch 

B. Dynamic prefetch 

C. Sequential prefetch 

D. Skip sequential prefetch 

Answer: B 

Explanation: