Ucertify C2090-612 Questions are updated and all C2090-612 answers are verified by experts. Once you have completely prepared with our C2090-612 exam prep kits you will be ready for the real C2090-612 exam without a problem. We have Renovate IBM C2090-612 dumps study guide. PASSED C2090-612 First attempt! Here What I Did.
♥♥ 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. Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?
A. The dynamic statement cache is enabled.
B. The client application contains some explainable statements.
C. The PLAN_TABLE and DSN_STATEMENT_CACHE tables must be created using a EBCDIC encoding scheme.
D. 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.
Answer: C
Q32. 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:
Q33. Unnecessary REORGs of indexes may be avoided by which of the following?
A. Use the SYSIBM.SYSINDEXSPACESTATS table.
B. Use the REPORT utility to determine the degree of organization.
C. Use the CHANGELIMIT keyword when creating an image copy of the index.
D. Use the CHECK INDEX utility to find out if the index needs to be reorganized.
Answer: A
Explanation:
Q34. You take image copies of your table spaces every night. Since you cannot afford any data outage, you use the SHRLEVEL CHANGE option on your COPY utility control statement. Assume that write operations currently run on your table space while the image copies are being performed. Which of the following statements is true?
A. Every FLASHCOPY generated with SHRLEVEL CHANGE will automatically be consistent.
B. If you use the generated SHRLEVEL CHANGE option with RECOVER .. TOCOPY later on,
DB2 determines the open URs and backs them out so that in the end your data will be consistent.
C. You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies generated during the same utility execution will be inconsistent.
D. You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies generated during the same utility execution will also be consistent.
Answer: D
Explanation:
Q35. 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:
Q36. What kind of information is stored in SYSIBM.SYSCOPY?
A. General information needed for recovery.
B. Only information about existing image copies.
C. Information about currently running and stopped copy jobs.
D. Only information about objects which are currently in copy pending.
Answer: A
Explanation:
Q37. What is a potential consideration when using triggers?
A. They are not invoked by the LOAD REPLACE utility.
B. When using views, the underlying tables cannot have a trigger defined.
C. RI and check constraints are evaluated prior to any trigger invocation.
D. They run in a WLM managed address space, so invoking them frequently (e.g. when using a row level trigger) can be costly.
Answer: A
Explanation:
Q38. Which of the following statements is NOT correct?
A. UNLOAD with NOPAD improves performance.
B. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).
C. Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.
D. Clone table allows replacing data without renames and rebinds to support online load replace.
Answer: B
Q39. 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:
Q40. Which minimum system privilege allows you to create a trusted context?
A. DBADM
B. SECADM
C. SYSCTRL
D. ACCESSCTRL
Answer: B
Explanation: