we provide Free IBM C2090-612 exam answers which are the best for clearing C2090-612 test, and to get certified by IBM DB2 10 DBA for z/OS. The C2090-612 Questions & Answers covers all the knowledge points of the real C2090-612 exam. Crack your IBM C2090-612 Exam with latest dumps, guaranteed!
♥♥ 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. 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:
Q52. For monitoring space growth over time, which statistics should NOT be considered?
A. SYSIBM.SYSTABLEPART_HIST CARDF, SPACEF SYSIBM.SYSINDEXPART_HIST CARDF, SPACEF
B. SYSIBM.SYSTABLEPART CARDF, SPACEF SYSIBM.SYSINDEXPART CARDF, SPACEF
C. SYSIBM.SYSTABLESPACE DSSIZE, AVGROWLEN SYSIBM.SYSINDEXES PIECESIZE, AVGKEYLEN
D. SYSIBM.SYSTABLESPACESTATS SPACE SYSIBM.SYSINDEXSPACESTATS SPACE
Answer: C
Explanation:
Q53. Which clone table statement is correct?
A. A clone table can have its own indexes.
B. A clone table has its own catalog statistics.
C. The clone and base tables share a table space.
D. The clone and base tables must have different schema names.
Answer: C
Explanation:
Q54. Altering the DSSIZE is allowed for what type of table space?
A. XML table space.
B. Universal table space.
C. Segmented table space.
D. DSSIZE cannot be altered.
Answer: B
Explanation:
Q55. 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:
Q56. 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
Q57. 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:
Q58. 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:
Q59. What is the appropriate action to maintain data consistency if your page set is in REFP restrictive state?
A. Recover the table space to current.
B. Run the REORG utility with SHRLEVEL NONE.
C. Run a Point In Time RECOVER or the LOAD REPLACE utility.
D. Issue command -START DB(yourdb) SP(yourtbspace) ACCESS(FORCE).
Answer: C
Explanation:
Q60. During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?
A. RBA
B. LRSN
C. ROWID
D. SYSPITRT
Answer: B
Explanation: