Practical of C2090-311 brain dumps materials and testing material for IBM certification for IT specialist, Real Success Guaranteed with Updated C2090-311 pdf dumps vce Materials. 100% PASS IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 exam Today!
2021 May C2090-311 Study Guide Questions:
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. What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to populate a column-organized table and a statistics profile does not exist?
A. A warning is returned and no statistics are collected.
B. An error is returned and the table is placed in "load pending" state.
C. A statistics profile is automatically generated before the load is allowed to continue.
D. The Load utility uses the same RUNSTATS command options as those used during an automatic runstats operation.
Answer: C
Q3. How is the Query Workload Tuner license installed and enabled?
A. With Data Studio, using the license activation kit.
B. By executing the db2licm command after data server installation.
C. With the Optim Performance Manager Server, using the license activation kit.
D. By running the Query Workload Tuner license activation command on the appropriate WebSphere server.
Answer: A
Rebirth C2090-311 rapidshare:
Q4. 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
Q5. Which statement about expression-based indexes is true?
A. The RUNSTATS command cannot be used to collect statistics for expression-based indexes.
B. Expression-based indexes must always be defined as UNIQUE to prevent duplicate index keys.
C. Expression-based index keys consist of a concatenation of one or more specified table columns.
D. The index key values of expression-based indexes are not the same as the values in the corresponding table columns.
Answer: D
Q6. 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
Precise C2090-311 preparation labs:
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. 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
Q9. 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
Q10. When does space reclamation for a column-organized table normally occur?
A. Whenever an individual row is deleted.
B. Whenever an individual row is updated.
C. After all rows in an extent have been updated.
D. After all rows in an extent where updates took place have been deleted.
Answer: A