Validated of C2090-612 brain dumps materials and item pool for IBM certification for examinee, 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
Q21. 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
Q22. A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?
A. The data is only stored in the auxiliary table.
B. The data is only stored in the base table.
C. The complete data is stored both in auxiliary and in base table.
D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.
Answer: B
Explanation:
Q23. Which statement is NOT true?
A. REORG table space to materialize pending definition changes for a table space.
B. REORG with SHRLEVEL CHANGE would automatically detect which threads need to be canceled before switch phase.
C. DSNACCOX can be used for collecting data for table space and index space for getting recommendations when to run REORG, RUNSTATS or COPY.
D. REORG of index space could be eliminated because the list prefetch of index leaf pages in DB2 V10 is based on non-leaf page information.
Answer: B
Q24. Which DSNZPARM parameter controls the number of locks that may be acquired on a table space?
A. NUMLKUS
B. MAXUSRS
C. NUMLKTS
D. MXDTCACH
Answer: C
Explanation:
Q25. What is the result of the command -RECOVER POSTPONED CANCEL if the postponed-abort thread that you cancel was in the middle of a series of updates when DB2 abended?
A. The underlying page sets are stopped.
B. The underlying page sets are placed in REFP restrictive state.
C. The underlying page sets are placed in REORP restrictive state.
D. No restrictive state is set. It is your responsibility to ensure data consistency.
Answer: B
Explanation:
Q26. Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
A. ALTER TABLE TB1 AUDIT CHANGES;
B. ALTER TABLE TB1 ADD COLUMN COLC DATE;
C. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
D. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS SECURITY LABEL;
Answer: B
Explanation:
Q27. A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?
A. Specify the column names to be hashed.
B. Create a unique index on the hash columns.
C. Create a clustering index on the hash columns.
D. Create a unique clustering index on the hash columns.
Answer: A
Explanation:
Q28. For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?
A. Catalog tables
B. Directory tables
C. Auxiliary tables
D. Declared global temporary tables
Answer: A
Explanation:
Q29. If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?
A. The next sort step will perform two sorts.
B. There are multiple sorts in the plan step.
C. One sort in the plan step will accomplish two tasks.
D. Two sorts are performed on the new table of a star join.
Answer: C
Explanation:
Q30. You have to design a table and application layout, in which automatic number generation is used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which statement is true?
A. Neither Identity nor Sequence can deliver this functionality.
B. Identity can deliver this functionality, but Sequence cannot.
C. Identity cannot deliver this functionality, but Sequence can.
D. Identity and Sequence can both deliver this functionality.
Answer: C
Explanation: