Ucertify C2090-312 Questions are updated and all C2090-312 answers are verified by experts. Once you have completely prepared with our C2090-312 exam prep kits you will be ready for the real C2090-312 exam without a problem. We have Improve IBM C2090-312 dumps study guide. PASSED C2090-312 First attempt! Here What I Did.
♥♥ 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
Q31. Which component is NOT shared between DB2 data sharing members?
A. SCA
B. IRLM
C. DB2 catalog
D. DB2 directory
Answer: C
Q32. What is a general recommendation for when to rebind?
A. After a backup is taken.
B. After a subsystem restart.
C. Before maintenance is applied.
D. After a major change in data volume.
Answer: B
Q33. As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action?
A. Issue the ACCESS command with appropriate keywords.
B. Issue the ARCHIVE command with the appropriate keywords.
C. Issue the STOP command for the appropriate set of statistics.
D. Issue the ALTER command with the appropriate memory location.
Answer: A
Q34. DB2 will not allow certain processing to occur when the soft limit of RBA TFF800000000'x is reached and an object's RBA remains in basic 6-byte format.
What processing is NEVER allowed?
A. Changes to the BSDS.
B. RECOVER to CURRENT.
C. REORGwith RBALRSN_CONVERSION EXTENDED.
D. SQL update activities (INSERT. UPDATE, DELETE, MERGE).
Answer: C
Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.admin/src/tpc/db2z_r balrsnlimitsreached.dita
Q35. 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
Q36. Which type of column can be dropped from a table via the ALTER TABLE ... DROP COLUMN ... SQL statement?
A. XML column
B. LOB column
C. DOCID column
D. Hidden ROWID column
Answer: A
Q37. 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
Q38. 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
Q39. Which SQL statement can be used to create a data type that will represent possible speed limit values, with valid values not greater than 99, and to create a table that contains route numbers and the maximum speed limit for each route?
A. CREATE TYPE SPEEDJJMIT AS SMALLINT; CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT, MAX_SPEED SPEEDJJMIT);
B. CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEEDJJMIT);
C. CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. SPEED_LIMIT);
D. CREATE TYPE SPEEDJJMIT USING DECIMAL(2.0); CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEED_LIMIT);
Answer: B