High value of C2090-612 torrent materials and braindumps for IBM certification for IT candidates, Real Success Guaranteed with Updated C2090-612 pdf dumps vce Materials. 100% PASS DB2 10 DBA for z/OS exam Today!


♥♥ 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. Which trace gives information about frequent log space shortages? 

A. Audit trace class(8) 

B. Statistics trace class(3) 

C. Accounting trace class(10) 

D. Performance trace class(4) 

Answer: B 

Explanation: 


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

A. Does not apply to threads that were defined with RELEASE(COMMIT). 

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

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

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

Answer: C 

Explanation: 


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

A. It is not mandatory to have an index on the foreign key columns but it can help to avoid locking problems. 

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

C. 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. 

D. 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: 


Q64. The UNLOAD utility can be used to do which of the following functions? 

A. Unload compressed data. 

B. Unload rows from a FlashCopy image copy. 

C. Unload data from an image copy of an index. 

D. Unload rows from an image copy that has rows from a dropped table. 

Answer: A 

Explanation: 


Q65. You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized? 

A. Audit trace class(4) 

B. Monitor trace class(6) 

C. Performance trace class(3) 

D. Accounting trace class(1,2,3,7,8) 

Answer: C 

Explanation: 


Q66. What is the DSNZPARM that determines the maximum amount of temporary storage in the work file data base for a single user at any given time? 

A. MAXRBLK 

B. MAXDBAT 

C. MAXKEEPD 

D. MAXTEMPS 

Answer: D 

Explanation: 


Q67. Which ALTER TABLE statement will generate a new table space version? 

A. ALTER TABLE ... ADD PARTITION ... 

B. ALTER TABLE ... ADD COLUMN COL2 ... 

C. ALTER TABLE ... DATA CAPTURE CHANGES ... 

D. Altering an already existing VARCHAR column on the table to shorten its maximum length. 

Answer: B 

Explanation: 


Q68. How do you enable parallelism in a dynamic SQL statement? 

A. BIND with DEGREE(1) 

B. BIND with DEGREE(ANY) 

C. Use SET CURRENT DEGREE = ANY 

D. Use SET CURRENT DEGREE = '1' 

Answer: C 

Explanation: 


Q69. Poorly tuned memory can affect application performance, such as having sequential prefetch turned off. Which statistic should you monitor from the statistics report to be sure this is not occurring? 

A. PREF.DISABLED-NO BUFFER 

B. PREF.DISABLED-NO READ ENG 

C. BUFF.UPDATES/PAGES WRITTEN 

D. PAGES WRITTEN PER WRITE I/O 

Answer: A 

Explanation: 


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

A. To increase free space. 

B. Because the clustering index has to match the primary index. 

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

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

Answer: C 

Explanation: