Testking offers free demo for C2090-312 exam. "IBM DB2 11 DBA for z/OS", also known as C2090-312 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-312 exam, will help you answer those questions. The C2090-312 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-312 exams and revised by experts!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-312 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-312 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-312-exam-dumps.html
Q21. 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
Q22. Which is NOT a valid value for the KEYWORDS column in the DSN_PROFILES_ATTRIBUTES table?
A. MONITOR THREAD
B. MONITOR IDLE THREADS
C. MONITOR CONNECTIONS
D. MONITOR ACTIVE THREADS
Answer: B
Q23. 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
Q24. 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
Q25. Which statement is true for data in columns defined with data type XML?
A. Data stored in XML columns cannot be indexed.
B. It is possible to define the XML column with an INLINEJ.ENGTH.
C. You can partially UPDATE, DELETE from, and INSERT into an XML document.
D. If you want to change an existing XML document, you have to replace the whole document in the XML column.
Answer: C
Q26. The degree of parallelism can vary for the REBUILD INDEX utility.
What action should be taken to limit the use of real memory using the REBUILD INDEX utility?
A. Increase the value of the PARALLEL option.
B. Decrease the value of the PARALLEL option.
C. Increase the value in the CURRENT DEGREE special register.
D. Decrease the value in the CURRENT DEGREE special register.
Answer: A
Q27. Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
A. A period-specification placed in the FROM clause of a subselect.
B. A period-specification placed in the WHERE clause of a subselect
C. A SELECT statement predicate against the transaction start ID of the base table.
D. A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect.
E. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal table.
Answer: C,E
Q28. What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?
A. This stored procedure helps you monitor currently running threads.
B. You can create a detailed report of currently running and stopped utilities.
C. This stored procedure materializes SYSIBM.SYSSTATFEEDBACK for the page sets you specify as input parameter.
D. You can create RUNSTATS profiles and RUNSTATS recommendations for DB2 tables in your DB2 subsystem.
Answer: D
Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.perf/src/tpc/db2z_sp_ adminutlmonitor.dita?cp=SSEPEK_11.0.0%2F6-0-6-1-4-5
Q29. Index versions are created when certain schema changes are committed. Which schema change results in a new index version being created?
A. Issue the ALTER INDEX REGENERATE statement.
B. Use the ALTER INDEX statement to add a column to an index that was built with DEFINE NO.
C. Add a new column to both a table and an index in the same commit operation when the table is in a partition-by-growth table space and the index is built with DEFINE YES.
D. When you extend the length of a varying-length character (VARCHAR data type) or varying-length graphic (VARGRAPHIC data type) column that is contained in one or more indexes that are defined with the NOT PADDED option.
Answer: B
Q30. A hotel prices its rooms differently at different times of the year. For example, Room 101 rents for $100 per night January through March, $150 per night April through September, and $80 per night October through December.
Which type of table could be used to implement the time-based rate changes?
A. A rate-period temporal table
B. A range-based temporal table
C. A system-period temporal table
D. An application-period temporal table
Answer: D
9. If the OPTHINTS subsystem parameter is set to YES, and you issue the following DB2 command relating to optimization parameter hints:
BIND QUERY LOOKUP (YES)
what is the result of the execution of this command?
A. A list of queries that are in error is produced.
B. Updated values are placed in SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.
C. New values are inserted into the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.
D. Messages containing only the status of rows in catalog tables SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN.
Answer: B
Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc/db2z_ cmd_bindquery.dita?cp=SSEPEK_11.0.0%2F10-1-1-0-0-2