Exambible 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 Abreast of the times 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
Q51. 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:
Q52. Which authority level allows a user to run utilities that change the data in an application database?
A. DBCTRL
B. SYSOPR
C. DBMAINT
D. INSTALL SYSOPR
Answer: A
Explanation:
Q53. Which of the following types of SQL statements are NOT eligible to be stored in the dynamic SQL statement cache?
A. MERGE
B. INSERT
C. SELECT
D. OPEN
Answer: D
Explanation:
Q54. In a data sharing environment, how is the LRSN value created?
A. It is selected from the DB2 catalog.
B. It is generated from a sequence object.
C. It is derived from the sysplex timer (store clock).
D. It is derived from combining RBAs from multiple members.
Answer: C
Explanation:
Q55. Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)
A. SECADM authority.
B. ACCESSCTRL authority.
C. DATAACCESS authority.
D. SYSADM authority when SEPARATE_SECURITY=NO.
E. The owner of the object as he/she has that authority implicitly.
Answer: A,D
Explanation:
Q56. DB2 10 is in enabling-new-function mode* after migrating from Version 8, which statement is correct?
A. The DB2 subsystem was at some point in in NFM.
B. The DB2 subsystem can still fall back to DB2 Version 8.
C. Coexistence is allowed with a DB2 9 data sharing group member.
D. The asterisk (*) indicates objects created in NFM can no longer be accessed.
Answer: A
Explanation:
Q57. In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used?
A. GBP32
B. SCA
C. LOCK
D. GBP0
Answer: B
Explanation:
Q58. The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?
A. Filter factor information.
B. Stage 1 and stage 2 information.
C. Number of columns used in an index.
D. Number of times an SQL statement is executed.
Answer: D
Explanation:
Q59. Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pending state AND creates an entry in SYSIBM.SYSCOPY?
A. Run the BACKUP SYSTEM utility.
B. Run the REPAIR SET NOCOPYPEND utility.
C. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.
D. Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 - 10.
Answer: C
Q60. Which of the following results in improving performance of a load job to load data into an indexed partitioned table space with multiple indexes?
A. LOG YES
B. PREFORMAT
C. SORTKEYS integer
D. convert input data
Answer: C
Explanation: