Proper study guides for Abreast of the times IBM IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 certified begins with IBM C2090-311 preparation products which designed to deliver the Vivid C2090-311 questions by making you pass the C2090-311 test at your first time. Try the free C2090-311 demo right now.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-311 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-311 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-311-exam-dumps.html
Q11. Which monitoring function can be used to determine how many times an SQL statement has referenced a particular column-organized table within a specific period of time?
A. MON_GET_TABLE()
B. MON_GET_TABLESPACE()
C. MON_GET_UNIT_OF_WORK()
D. MON_GET_TABLE_USAGE_LIST()
Answer: A
Q12. Which type of compression is typically used with column-organized tables?
A. BLU compression
B. Value compression
C. Actionable compression
D. Adaptive row compression
Answer: A
Q13. An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created for a table named EMPLOYEE.
If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:
RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE ONLY
Which command will create a statistics profile on the EMPLOYEE table?
A. RUNSTATS ON TABLE employee USE PROFILE
B. RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1
C. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL
D. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1 GENERATE PROFILE
Answer: C
Q14. What will cause the creation of a column-organized table to fail?
A. Setting the database code set to UNICODE.
B. Setting the DFT_DEGREE database configuration parameter to ANY.
C. Setting the AUTO_RUNSTATS database configuration parameter to ON.
D. Setting the UTILJHEAP_SZ database configuration parameter to at least 1.000,000 pages.
Answer: C
Q15. What is a DB2 Advanced Copy Services (ACS) script used for?
A. To install and configure DB2 Advanced Copy Services.
B. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services.
C. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.
D. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACS API vendor library.
Answer: D
Q16. If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?
A. -1
B. 1
C. ON
D. ANY
Answer: A
Q17. If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two capabilities are available?
A. Multi-tenancy
B. Workload consolidation
C. Independent tuning member
D. Broadcasting STMM tuning decisions to all members
E. Single INSTANCE_MEMORY instance configuration memory setting
Answer: D,E
Q18. What type of table can be converted into a column-organized table with the db2convert command?
A. A range partitioned table
B. A materialized query table
C. A row-organized user table
D. A declared global temporary table
Answer: A