we provide Downloadable IBM C2090-311 free download which are the best for clearing C2090-311 test, and to get certified by IBM IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1. The C2090-311 Questions & Answers covers all the knowledge points of the real C2090-311 exam. Crack your IBM C2090-311 Exam with latest dumps, guaranteed!
♥♥ 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
Q1. Which statement about column-organized tables is true?
A. Databases with column-organized tables can be federated.
B. Schemas that include column-organized tables can be transported.
C. Sort memory can be automatically tuned in environments containing column-organized tables.
D. Queries that use the Currently Committed semantics can be used with column-organized tables.
Answer: A
Q2. If the DB2_WORKLOAD registry variable has not been set which database manager configuration parameter must be modified, before a query that accesses a column-organized table can be executed?
A. INTRA_PARALLEL
B. QUERY_HEAP_SZ
C. MAXIMUM DEGREE
D. SHEAPTHRES SHR
Answer: C
Q3. Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?
A. EHL is enabled by default in DB2 10.5 pureScale environments.
B. There are three EHL states available: SHARED, DIRECT_ACCESS and NONSHARED.
C. Only regular tables, temporary tables, and non-partitioned indexes can take advantage of EHL.
D. EHL is designed to improve DB2 pureScale performance by avoiding CF communications for tables that are accessed from only one member.
Answer: A
Q4. Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?
A. Row compression
B. Index compression
C. Backup compression
D. Temporary table compression
Answer: C
Q5. Which two sources can be used to provide input to the InfoSphere Optim Query Workload Tuner that generate EXPLAIN information when creating the query workload?
A. db2pd
B. Routines
C. EXPLAIN tables
D. Snapshot monitor
E. ACTIVITIES event monitors
Answer: C,D
Q6. In which type of database are column-organized tables supported?
A. Partitioned databases.
B. DB2 pureScale databases.
C. Databases whose code set is Unicode.
D. Databases whose code set is Non-Unicode.
Answer: A
Q7. Which statement regarding NOT ENFORCED unique constraints is true?
A. NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.
B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data access plan.
C. Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a unique index.
D. When attempting to insert data that does not conform to the NOT ENFORCED unique constraint, an error will be returned and the record will not be inserted.
Answer: A
Q8. 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
Q9. 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
Q10. Which scenario does NOT require intraquery parallelism?
A. The execution of the LOAD command against an empty column-organized table.
B. A DML operation that references a populated column-organized table.
C. The execution of the RUNSTATS command against a populated column-organized table.
D. The addition of a primary key constraint to an empty column-organized table.
Answer: D