Actualtests 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

Q1. Which statement regarding triggers is true? 

A. A trigger can use global variables and change their contents. 

B. A trigger can use global variables but cannot change their contents. 

C. A trigger cannot use global variables but can change their contents. 

D. A trigger cannot use global variables and cannot change their contents. 

Answer: B 


Q2. You have defined the array type PHONENUMBERS using the following DDL: 

CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50]; 

You also defined a variable named RECENT_CALLS based on this new array type as follows: CREATE VARIABLERECENT_CALLS PHONENUMBERS: 

Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS? 

A. SET LIST_SIZE = MAX(RECENT_CALLS) 

B. SET LIST_SIZE = ARRAY_MAX(RECENT_CALLS) 

C. SET LIST_SIZE = ARRAY_LAST(RECENT_CALLS) 

D. SET LIST_SIZE = MAX_CARDINALITY(RECENT_CALLS) 

Answer: B 


Q3. Which group of DB2 ACCOUNTING trace CLASSES must be started to collect accounting information for PLANS and PACKAGES? 

A. CLASS(2,7,8) 

B. CLASS(1,2,3) 

C. CLASS(1,5,10) 

D. CLASS(1, 2,3,7,8) 

Answer: D 


Q4. 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 


Q5. Which component is NOT shared between DB2 data sharing members? 

A. SCA 

B. IRLM 

C. DB2 catalog 

D. DB2 directory 

Answer: C 


Q6. 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 


Q7. In order to use a literal replacement for a dynamic SQL caching statement what must be true about the statement? 

A. It cannot be a join. 

B. The authids do not have to match. 

C. It must include more than one literal. 

D. It cannot have both literals and parameter markers. 

Answer: D 


Q8. Which DB2 subsystem parameter is used to control the number of concurrent inbound DDF connections? 

A. MAXDBAT 

B. CTHREAD 

C. CONDBAT 

D. CONTSTOR 

Answer: C 


Q9. From where does the cross-loader function allow you to load data? 

A. From an input file including all columns. 

B. From a cursor including LOB columns but not including XML columns. 

C. From a cursor including XML columns but not including LOB columns. 

D. From a cursor including all LOB and XML columns except the ROWID column. 

Answer: A 


Q10. Which command populates the EXPLAIN tables but does not create a package? 

A. REBINDCOPY 

B. REBINDEXPLAIN(NO) 

C. REBINDEXPLAIN(YES) 

D. REBIND EXPLAIN(ONLY) 

Answer: D 

Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc/db2z_ bindoptexplain.dita