Exam Code: C2090-312 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM DB2 11 DBA for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-312 Exam.
♥♥ 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. 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. Which address space should be classified with the highest priority WLM service class?
A. DIST
B. IRLM
C. DBM1
D. MSTR
Answer: B
Q3. 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
Q4. You are trying to reduce the transaction CPU cost by using KEEPDYNAMIC(YES). Which subsystem parameter would you increase to improve Local Dynamic Cache Hit Ratio and reduce the number of short prepares?
A. MAXRBLK
B. MAXKEEPD
C. MAXTEMPS
D. CONTSTOR
Answer: B
Q5. 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
Q6. What does the UNLOAD utility allow you to unload?
A. Index entries from an index image copy.
B. Rows from an image copy after the table has been dropped.
C. Rows from an image copy after columns have been dropped.
D. Rows from a sequential image copy created by the COPYTOCOPY utility.
Answer: D
Q7. The TCP/IP Already Verified (TCPALVER) DB2 system parameter controls whether DB2 accepts a TCP/IP connection requests. Which statement is NOT a valid value?
A. TCPALVER=NO
B. TCPALVER=YES
C. TCPALVER=SERVER_SECURE
D. TCPALVER=SERVERENCRYPT
Answer: B
Q8. Which table characteristic is a good attribute for the exploitation of hash access?
A. At least 20 rows fit on a data page.
B. DB2 uses range scans to access rows in the table.
C. The size of individual rows in the table vary greatly.
D. DB2 uses sequential lookups to access data in the table.
Answer: D
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. When defining a check constraint on a populated table and the value of the special register CURRENT RULES is 'DB2’.
What is the result of executing the DDL statement?
A. It is rejected by the database system.
B. The table space is placed in CHKP status.
C. It is checked against only all existing rows in the table.
D. It is checked against only new rows as they are added to the table.
Answer: C