Exact of C2090-312 exam prep materials and tutorials for IBM certification for candidates, Real Success Guaranteed with Updated C2090-312 pdf dumps vce Materials. 100% PASS IBM DB2 11 DBA for z/OS exam Today!
2021 May C2090-312 Study Guide Questions:
Q41. Which statement about an array data type is true?
A. User-defined data types are allowed in an array.
B. An array is a built-in data type and can only be numeric.
C. Arrays can be used as direct input to a select-statement predicate.
D. Associative arrays can only use INTEGER and VARCHAR data types as indexes.
Answer: D
Q42. An application receives an 00C90110 reason code. See the following manual explanation of the code.
" 00C90110
Explanation:The data manager detected an inconsistent data condition. This may be caused by an inconsistency in either the DB2P' catalog or the DB2 directory. In this case, the OBD for the requested OBID cannot be located in the database descriptor (DBD). The DBD in storage may be inconsistent. Specifically, the OBDDMAP(OBID) array element should contain an offset into the DBD where the OBD should be located. However, in this case the OBD expected was not at the indicated offset.To prevent further damage and possible loss of data, the inconsistency must be corrected before any further SQL access is attempted to this database."
Even though the problem cannot be recreated, you still want to find out what caused this and you want to collect additional information for the IBM support team.
Which utilities and service aids CANNOT help to provide useful additional info to diagnose the problem?
A. REPAIR
B. REPORT
C. DIAGNOSE
D. DSN1LOGP
Answer: C
Latest C2090-312 practice test:
Q43. Which statement is true if a table space is created using the "FOR UPDATE nn" (where nn is a number) clause?
A. The first nn UPDATE operation(s) will use an indirect reference.
B. Only the first nn UPDATE operation(s) on the table will be processed.
C. nn% space is reserved per page for future UPDATE operations to reduce indirect reference.
D. nn row locations per page are kept for future UPDATE operations to reduce indirect reference.
Answer: A
Q44. What is the least disruptive way of externalizing real-time statistics for table space DB1TS1?
A. -SET LOG LOGLOAD(O)
B. -DISPLAY DB(DB1)SPACENAM(TS1)
C. RUNSTATS TABLESPACE DB1TS1
D. -ACCESS DB(DB1) SPACENAM(TSI) MODE(STATS)
Answer: C
Free C2090-312 free demo:
Q45. Arrays are based on a built-in data type. On which built-in data type can an array NOT be based?
A. XML
B. CLOB
C. DBCLOB
D. VARBINARY
Answer: A
Q46. Which component is NOT shared between DB2 data sharing members?
A. SCA
B. IRLM
C. DB2 catalog
D. DB2 directory
Answer: C