Exam Code: C2090-612 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10 DBA for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-612 Exam.
2021 May C2090-612 Study Guide Questions:
Q1. The I/O patterns for objects in database NEWBILL need to be reviewed in detail. All of the NEWBILL work runs under a single plan, NEWBILLPL. What START TRACE command should be used to gather the I/O information needed for the objects in database NEWBILL?
A. START TRACE(AUDIT) PLAN(NEWBILLPL)
B. START TRACE(IO) CLASS(ALL) PLAN(NEWBILLPL)
C. START TRACE(PERFM) CLASS(3) PLAN(NEWBILLPL)
D. START TRACE(ACCT) CLASS(1,2,3) PLAN(NEWBILLPL)
Answer: C
Explanation:
Q2. 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
Q3. Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?
A. CHECK LOB
B. CHECK INDEX
C. DSN1COPY
D. DSN1CHKR
Answer: D
Explanation:
Refresh C2090-612 latest exam:
Q4. 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:
Q5. DB2 workfiles are critical to performance of applications. Which of the following will NOT assist with achieving best performance for workfile usage?
A. Create several 4K and 32K workfiles.
B. Assign workfiles to their own bufferpools.
C. Assign workfiles to their own DASD volumes.
D. Create one large workfile for the data sharing group.
Answer: D
Explanation:
Q6. In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)
A. Column CLUSTERING in SYSIBM.SYSINDEXES
B. Column LEAFDIST in SYSIBM.SYSINDEXPART
C. Column CLUSTERRATIOF in SYSIBM.SYSINDEXES
D. Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS
E. Columns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART
Answer: A,D
Explanation:
Certified C2090-612 dump:
Q7. Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?
A. 1
B. 4
C. 5
D. 6
Answer: D
Explanation:
Q8. 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:
Q9. DB2 does not take system checkpoints in which circumstance?
A. During an application rollback.
B. At the end of a successful restart.
C. When switching from one active log data set to another.
D. When a specified number of log records are created or after a specified number of minutes, whichever occurs first.
Answer: A
Explanation:
Q10. In the CFRM policy, what is the purpose of the PREFLIST?
A. To identify the size of the structure.
B. To identify all the DB2 members in the group.
C. To identify the preferences for DB2 restart in the event of a disconnection.
D. To identify the preferences for structure rebuild/reallocation during a coupling facility failure.
Answer: D
Explanation: