Downloadable of C2090-312 practice question materials and resource for IBM certification for consumer, Real Success Guaranteed with Updated C2090-312 pdf dumps vce Materials. 100% PASS IBM DB2 11 DBA for z/OS exam Today!
2021 Apr C2090-312 Study Guide Questions:
Q1. You are having problems accessing SYSIBM.SYSTABLES in your data sharing environment and you want to know who is using the table space DSNDB06.SYSTSTAB.
How would you find this information?
A. -DIS THREAD (') TYPE(SYSTEM)
B. -DIS DB(DSNDB06) SP(SYSTSTAB) USE
C. -DIS GROUPBUFFERPOOL(GBPO) CONNLIST(YES)
D. -DIS BUFFERPOOL (BPO) DB(DSNDB06) SP(SYSTSTAB) LIST(ACTIVE)
Answer: B
Q2. Given the following output:
DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS -DSNV402I _DB2D ACTIVE THREADS -NAME ST A REQ ID AUTHID PLAN ASID TOKEN DB2CALL T 17039 BBISS BBISS 00AF 19855 TSO T * 3 KSTTEST KSTTEST 0135 20212 A51OTEST N* 13 CICSTEST 0125 19625 You receive a call that user KSTTEST is holding resources and needs to be canceled.
Which command should be issued?
A. -CANCEL THREAD( 3)
B. -CANCEL THREAD(20212)
C. -CANCEL USER(KSTTEST)
D. User KSTTEST does not hold an active connection, no way he blocks anything.
Answer: A
Q3. When would DB2 NOT use list prefetch?
A. Fast log apply operations.
B. Reading leaf pages of a disorganized index.
C. RUNSTATS TABLESPACE without table sampling.
D. Incremental image copies of a table space defined with TRACKMOD YES.
Answer: B
Refresh C2090-312 study guide:
Q4. Which statement is true regarding table-controlled partitioned table spaces without a MAXVALUE specified?
A. If the partitioning key is ascending, DB2 prevents the INSERT of a row with a null value for the key column.
B. If the partitioning key is descending, DB2 prevents the INSERT of a row with a null value for the key column.
C. If the partitioning key is ascending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the first partition.
D. If the partitioning key is descending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the last partition.
Answer: C
Q5. 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
Q6. You must be able to process recoveries for DB2 objects to any point in time between now and two weeks ago.
What is the recommended amount of recovery data needed?
A. One set of SHRLEVEL(CHANGE) full image copies every two weeks that are kept for at least two weeks.
B. One set of SHRLEVEL(CHANGE) full image copy at least every week that are kept for at least three weeks as well as the active/archive logs during that time.
C. One set of SHRLEVEL(CHANGE) full images copies at least every week that are kept for at least two weeks as well as the active/archive logs during that time.
D. One set of SHRLEVEL(CHANGE) full images copies during week#1 and one set of SHRLEVEL(REFERENCE) incremental images copies during week #2, all are kept for at least two weeks.
Answer: D
Reference:http://www.gsebelux.com/system/files/GSE%20backup%20and%20recovery%20%20at %20KBC.pdf(page 10)
Certified C2090-312 courses:
Q7. 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
Q8. Given this statement:
RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH
Which statement is FALSE?
A. It resets all real-time statistics (RTS) for DB1TS1.
B. It resets all access path statistics for DB1TS1 in the catalog.
C. It invalidates the dynamic statement cache for table space DB1TS1.
D. It externalizes current access paths statistics for DB1 TS1 to HIST catalog tables.
Answer: C
Q9. What keyword establishes the maximum partition size of a partition-by-growth universal table space?
A. PART
B. DSSIZE
C. SEGSIZE
D. MAXPARTITIONS
Answer: C
Q10. DB2 AUDIT policies are defined by inserting rows into what DB2 Catalog table?
A. SYSIBM.SYSDBAUTH
B. SYSIBM.SYSAUTOALERTS
C. SYSIBM.SYSAUDITPOLICIES
D. SYSIBM.SYSTABLESPROFILES
Answer: C
Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.seca/src/tpc/db2z_se cadmauthority.dita(9th bullet)