C2090-311 - IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam

Go back to IBM

Example Questions

Which type of compression is typically used with column-organized tables? When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment? Which scenario does NOT require intraquery parallelism? How is the Query Workload Tuner license installed and enabled? What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track? Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster? 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? 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? What will cause the creation of a column-organized table to fail? What is a DB2 Advanced Copy Services (ACS) script used for? What type of table can be converted into a column-organized table with the db2convert command? Which statement about expression-based indexes is true? Which statement regarding NOT ENFORCED unique constraints is true? Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true? What are the correct steps to capture EXPLAIN information for column-organized tables? Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments? By default, the Optim Workload Table Organization Advisor will recommend converting row- organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much? 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? When does space reclamation for a column-organized table normally occur? In which type of database are column-organized tables supported? If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two capabilities are available? 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? What formula can be used to determine the average number of column-organized pages found in each read request? 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? If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default? Which command, when executed, will enable workload management for column-organized table workloads? Which statement about column-organized tables is true? When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width size for database tables? Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?

Study Guides